explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hV9o

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 14.283 ↑ 11.1 9 1

Limit (cost=0.42..213.05 rows=100 width=758) (actual time=14.236..14.283 rows=9 loops=1)

  • Buffers: shared hit=3674 dirtied=19
2. 14.280 14.280 ↑ 106.0 9 1

Index Scan using occurrence_occurrence_type_idx on occurrence occurrence0_ (cost=0.42..2,028.91 rows=954 width=758) (actual time=14.234..14.280 rows=9 loops=1)

  • Index Cond: ((occurrence_type)::text = 'ORDER_STATE_TIMEOUT_AVAILABLE'::text)
  • Filter: (created_date < '2020-05-19 00:46:00.991508-03'::timestamp with time zone)
  • Rows Removed by Filter: 1075
  • Buffers: shared hit=3674 dirtied=19
Planning time : 0.241 ms
Execution time : 14.307 ms