explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GEKX

Settings
# exclusive inclusive rows x rows loops node
1. 59.093 24,731.613 ↑ 28,919.0 3 1

GroupAggregate (cost=257,157.42..265,993.29 rows=86,757 width=70) (actual time=24,666.068..24,731.613 rows=3 loops=1)

  • Group Key: (date_part('month'::text, e.dat_sost)), e.ogai_sost_kod
2. 227.416 24,672.520 ↓ 1.6 212,374 1

Sort (cost=257,157.42..257,488.51 rows=132,434 width=43) (actual time=24,649.922..24,672.520 rows=212,374 loops=1)

  • Sort Key: (date_part('month'::text, e.dat_sost))
  • Sort Method: external merge Disk: 9,624kB
3. 94.822 24,445.104 ↓ 1.6 212,374 1

Hash Right Join (cost=224,712.27..243,446.26 rows=132,434 width=43) (actual time=24,093.423..24,445.104 rows=212,374 loops=1)

  • Hash Cond: (r.docs_id = e.docs_id)
4. 48.232 262.169 ↑ 1.1 7,563 1

Gather (cost=1,000.00..18,255.47 rows=8,004 width=11) (actual time=1.559..262.169 rows=7,563 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 213.937 213.937 ↑ 1.4 1,891 4 / 4

Parallel Seq Scan on docs_executive_response r (cost=0.00..16,455.07 rows=2,582 width=11) (actual time=1.729..213.937 rows=1,891 loops=4)

  • Filter: (fssp_status = '15'::numeric)
  • Rows Removed by Filter: 247,967
6. 138.225 24,088.113 ↓ 1.6 212,160 1

Hash (cost=221,021.85..221,021.85 rows=132,434 width=36) (actual time=24,088.113..24,088.113 rows=212,160 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 7,795kB
7. 14,489.602 23,949.888 ↓ 1.6 212,160 1

Bitmap Heap Scan on docs_executive e (cost=76,145.33..221,021.85 rows=132,434 width=36) (actual time=9,484.928..23,949.888 rows=212,160 loops=1)

  • Recheck Cond: ((dat_sost >= date_trunc('month'::text, (('now'::cstring)::date - '2 mons'::interval))) AND ((ogai_sost_kod)::text = '45597'::text))
  • Rows Removed by Index Recheck: 470,738
  • Heap Blocks: exact=78,156 lossy=154,774
8. 24.347 9,460.286 ↓ 0.0 0 1

BitmapAnd (cost=76,145.33..76,145.33 rows=132,434 width=0) (actual time=9,460.286..9,460.286 rows=0 loops=1)

9. 160.541 160.541 ↓ 1.2 331,142 1

Bitmap Index Scan on docs_executive_dat_sost (cost=0.00..5,148.81 rows=279,889 width=0) (actual time=160.541..160.541 rows=331,142 loops=1)

  • Index Cond: (dat_sost >= date_trunc('month'::text, (('now'::cstring)::date - '2 mons'::interval)))
10. 9,275.398 9,275.398 ↓ 1.0 2,102,403 1

Bitmap Index Scan on docs_executive_status_id_kod (cost=0.00..70,930.05 rows=2,078,907 width=0) (actual time=9,275.398..9,275.398 rows=2,102,403 loops=1)

  • Index Cond: ((ogai_sost_kod)::text = '45597'::text)
Planning time : 0.451 ms
Execution time : 24,735.202 ms