explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KXpI

Settings
# exclusive inclusive rows x rows loops node
1. 32,510.531 38,315.595 ↓ 1.1 409,153 1

Bitmap Heap Scan on docs_executive e (cost=89,956.79..461,182.04 rows=384,781 width=22) (actual time=5,821.718..38,315.595 rows=409,153 loops=1)

  • Recheck Cond: ((dat_sost >= date_trunc('year'::text, (('now'::cstring)::date)::timestamp with time zone)) AND (dat_sost <= (('now'::cstring)::date - '1 day'::interval)) AND ((ogai_sost_kod)::text = '45597'::text))
  • Rows Removed by Index Recheck: 1,188,408
  • Heap Blocks: exact=63,390 lossy=384,970
2. 47.821 5,805.064 ↓ 0.0 0 1

BitmapAnd (cost=89,956.79..89,956.79 rows=384,781 width=0) (actual time=5,805.064..5,805.064 rows=0 loops=1)

3. 444.426 444.426 ↓ 1.1 919,581 1

Bitmap Index Scan on docs_executive_dat_sost (cost=0.00..16,838.16 rows=808,251 width=0) (actual time=444.426..444.426 rows=919,581 loops=1)

  • Index Cond: ((dat_sost >= date_trunc('year'::text, (('now'::cstring)::date)::timestamp with time zone)) AND (dat_sost <= (('now'::cstring)::date - '1 day'::interval)))
4. 5,312.817 5,312.817 ↓ 1.0 2,217,931 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..72,925.98 rows=2,145,293 width=0) (actual time=5,312.817..5,312.817 rows=2,217,931 loops=1)

  • Index Cond: ((ogai_sost_kod)::text = '45597'::text)
Planning time : 0.174 ms
Execution time : 38,344.936 ms