explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1n4p

Settings
# exclusive inclusive rows x rows loops node
1. 12,045.487 23,926.164 ↑ 5.9 972,353 1

Hash Join (cost=996,475.14..1,968,966.07 rows=5,704,167 width=8) (actual time=1,159.121..23,926.164 rows=972,353 loops=1)

  • Hash Cond: ((earn.peo_id = epv.peo_id) AND (earn.client_id = epv.client_id) AND (earn.voucher_id = epv.voucher_id))
2. 10,841.034 10,841.034 ↑ 1.0 16,016,823 1

Seq Scan on inf_epv_tsearn_rollup earn (cost=0.00..462,095.02 rows=16,035,402 width=65) (actual time=0.948..10,841.034 rows=16,016,823 loops=1)

3. 412.837 1,039.643 ↓ 1.0 620,997 1

Hash (cost=977,581.48..977,581.48 rows=606,095 width=84) (actual time=1,039.643..1,039.643 rows=620,997 loops=1)

  • Buckets: 32768 Batches: 32 Memory Usage: 2476kB
4. 23.093 626.806 ↓ 1.0 620,997 1

Gather (cost=13,889.11..977,581.48 rows=606,095 width=84) (actual time=62.367..626.806 rows=620,997 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 587.114 603.713 ↑ 1.2 206,999 3 / 3

Parallel Bitmap Heap Scan on epv (cost=12,889.11..915,971.98 rows=252,540 width=84) (actual time=45.627..603.713 rows=206,999 loops=3)

  • Recheck Cond: ((pay_date >= '2019-01-01'::date) AND (pay_date < '2020-03-17'::date))
  • Rows Removed by Index Recheck: 350
  • Filter: (status = 'PRNT'::text)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=14461 lossy=9867
6. 16.599 16.599 ↓ 1.0 621,000 1 / 3

Bitmap Index Scan on idx_epv_pay_date (cost=0.00..12,737.58 rows=606,115 width=0) (actual time=49.797..49.798 rows=621,000 loops=1)

  • Index Cond: ((pay_date >= '2019-01-01'::date) AND (pay_date < '2020-03-17'::date))