EXPLAIN (PostgreSQL)

From wikieduonline
Revision as of 16:59, 5 August 2021 by Welcome (talk | contribs) (Welcome moved page EXPLAIN to EXPLAIN (PostgreSQL))
Jump to navigation Jump to search


https://www.postgresql.org/docs/current/sql-explain.html


.../...
 ->  Index Scan using your_key on your_table your_table  (cost=0.43..8.39 rows=1 width=952) (actual time=1.030..1.030 rows=0 loops=39649)
       Index Cond: (id = your_id)
       Filter: (your_filter_id = ######)
       Rows Removed by Filter: 1
Planning Time: 0.441 ms
Execution Time: 50387.333 ms

Related terms

Activities

See also

Advertising: