explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bVYy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 17,105.162 ↑ 1.0 1 1

Finalize Aggregate (cost=1,603,129.34..1,603,129.35 rows=1 width=8) (actual time=17,105.161..17,105.162 rows=1 loops=1)

2. 182.889 17,280.509 ↓ 1.5 3 1

Gather (cost=1,603,129.13..1,603,129.34 rows=2 width=8) (actual time=17,105.151..17,280.509 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,230.517 17,097.620 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,602,129.13..1,602,129.14 rows=1 width=8) (actual time=17,097.620..17,097.620 rows=1 loops=3)

4. 8,214.826 15,867.103 ↑ 1.3 2,641,619 3 / 3

Parallel Hash Join (cost=292,442.52..1,593,815.45 rows=3,325,472 width=0) (actual time=13,149.382..15,867.103 rows=2,641,619 loops=3)

  • Hash Cond: (cm.check_id = c.id)
5. 5,736.466 5,736.466 ↑ 1.3 7,913,238 3 / 3

Parallel Index Only Scan using idx_citems_on_pid_and_dat_and_cid_and_p_check_item_id_and_sts on check_items cm (cost=0.56..1,174,403.94 rows=9,899,250 width=16) (actual time=0.039..5,736.466 rows=7,913,238 loops=3)

  • Index Cond: ((deleted_at IS NULL) AND (status = 2))
  • Heap Fetches: 0
6. 509.197 1,915.811 ↑ 1.2 710,073 3 / 3

Parallel Hash (cost=277,099.09..277,099.09 rows=882,629 width=16) (actual time=1,915.811..1,915.811 rows=710,073 loops=3)

  • Buckets: 131,072 Batches: 64 Memory Usage: 2,624kB
7. 1,406.614 1,406.614 ↑ 1.2 710,073 3 / 3

Parallel Seq Scan on checks c (cost=0.00..277,099.09 rows=882,629 width=16) (actual time=0.062..1,406.614 rows=710,073 loops=3)

  • Filter: ((business_date >= '2020-01-01'::date) AND (business_date <= '2020-06-01'::date))
  • Rows Removed by Filter: 1,391,643