explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PYoK

Settings
# exclusive inclusive rows x rows loops node
1. 5.325 6.034 ↑ 1.4 188 1

Bitmap Heap Scan on inspections_booking (cost=139.73..5,205.60 rows=261 width=2,432) (actual time=2.098..6.034 rows=188 loops=1)

  • Recheck Cond: (executor_id = 308693)
  • Filter: ((created_time >= '2019-05-01 00:00:00+00'::timestamp with time zone) AND (book_to_org_id = 252437))
  • Rows Removed by Filter: 7131
  • Heap Blocks: exact=3607
2. 0.709 0.709 ↑ 1.0 7,319 1

Bitmap Index Scan on inspections_booking_executor_id_bedf7882 (cost=0.00..139.66 rows=7,383 width=0) (actual time=0.709..0.709 rows=7,319 loops=1)

  • Index Cond: (executor_id = 308693)
Planning time : 0.191 ms