Difference between revisions of "EXPLAIN (PostgreSQL)"

From wikieduonline
Jump to navigation Jump to search
Line 15: Line 15:
 
== Related terms ==
 
== Related terms ==
 
* [[bitmap scan]]
 
* [[bitmap scan]]
 
+
* [[EXPLAIN ANALYZE]]
  
 
== Activities ==
 
== Activities ==

Revision as of 16:54, 5 August 2021


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: