explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8LPU

Settings
# exclusive inclusive rows x rows loops node
1. 49.883 287,557.532 ↑ 1.0 1 1

Aggregate (cost=66,414.13..66,414.14 rows=1 width=8) (actual time=287,557.532..287,557.532 rows=1 loops=1)

2. 273,824.424 287,507.649 ↓ 2.5 141,213 1

Bitmap Heap Scan on docs_executive e (cost=1,042.46..66,271.83 rows=56,922 width=0) (actual time=13,729.077..287,507.649 rows=141,213 loops=1)

  • Recheck Cond: (((status_id = '3'::numeric) AND ((ogai_sost_kod)::text = '45597'::text)) OR ((status_id = '4'::numeric) AND ((ogai_sost_kod)::text = '45597'::text)))
  • Rows Removed by Index Recheck: 160,297
  • Heap Blocks: exact=91,983 lossy=55,245
3. 0.001 13,683.225 ↓ 0.0 0 1

BitmapOr (cost=1,042.46..1,042.46 rows=57,033 width=0) (actual time=13,683.225..13,683.225 rows=0 loops=1)

4. 2,878.284 2,878.284 ↓ 8.7 35,624 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..73.55 rows=4,072 width=0) (actual time=2,878.284..2,878.284 rows=35,624 loops=1)

  • Index Cond: ((status_id = '3'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))
5. 10,804.940 10,804.940 ↓ 2.8 150,559 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..940.44 rows=52,961 width=0) (actual time=10,804.940..10,804.940 rows=150,559 loops=1)

  • Index Cond: ((status_id = '4'::numeric) AND ((ogai_sost_kod)::text = '45597'::text))
Planning time : 0.126 ms
Execution time : 287,560.619 ms