explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3J4p

Settings
# exclusive inclusive rows x rows loops node
1. 1.750 1.986 ↑ 1.1 2,814 1

Bitmap Heap Scan on price_item_raw (cost=72.05..11,040.71 rows=3,012 width=1,300) (actual time=0.337..1.986 rows=2,814 loops=1)

  • Recheck Cond: ((org_id = '141274359413721'::bigint) AND (deletion_time IS NULL))
  • Filter: ((last_invalidation_id < 36) OR (last_invalidation_id IS NULL))
  • Heap Blocks: exact=968
2. 0.236 0.236 ↑ 1.1 2,814 1

Bitmap Index Scan on pir_org_id (cost=0.00..71.29 rows=3,049 width=0) (actual time=0.236..0.236 rows=2,814 loops=1)

  • Index Cond: (org_id = '141274359413721'::bigint)
Planning time : 0.195 ms
Execution time : 2.148 ms