Difference between revisions of "EXPLAIN (PostgreSQL)"

From wikieduonline
Jump to navigation Jump to search
Line 6: Line 6:
  
 
  .../...
 
  .../...
   ->  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 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)
 
         Index Cond: (id = your_id)
 
         Filter: (your_filter_id = ######)
 
         Filter: (your_filter_id = ######)

Revision as of 10:36, 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

See also

Advertising: