explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4pN1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 18,056.359 ↑ 1.0 1 1

Finalize Aggregate (cost=1,020,504.99..1,020,505.00 rows=1 width=8) (actual time=18,056.359..18,056.359 rows=1 loops=1)

2. 205.478 18,256.816 ↓ 1.5 3 1

Gather (cost=1,020,504.77..1,020,504.98 rows=2 width=8) (actual time=18,054.611..18,256.816 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,132.727 18,051.338 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,019,504.77..1,019,504.78 rows=1 width=8) (actual time=18,051.337..18,051.338 rows=1 loops=3)

4. 7,452.585 16,918.611 ↑ 1.2 2,681,958 3 / 3

Parallel Hash Join (cost=289,224.51..1,011,161.09 rows=3,337,473 width=0) (actual time=14,256.495..16,918.611 rows=2,681,958 loops=3)

  • Hash Cond: (cm.check_id = c.id)
5. 7,462.201 7,462.201 ↑ 1.3 8,041,829 3 / 3

Parallel Index Only Scan using index_check_items_on_check_id on check_items cm (cost=0.56..593,122.87 rows=10,052,287 width=16) (actual time=0.465..7,462.201 rows=8,041,829 loops=3)

  • Heap Fetches: 0
6. 483.300 2,003.825 ↑ 1.2 710,073 3 / 3

Parallel Hash (cost=274,063.83..274,063.83 rows=872,089 width=16) (actual time=2,003.824..2,003.825 rows=710,073 loops=3)

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

Parallel Bitmap Heap Scan on checks c (cost=572.33..274,063.83 rows=872,089 width=16) (actual time=7.259..1,520.525 rows=710,073 loops=3)

  • Recheck Cond: ((business_date >= '2020-01-01'::date) AND (business_date <= '2020-06-01'::date))
  • Rows Removed by Index Recheck: 1,244,136
  • Heap Blocks: lossy=68,998
8. 2.912 2.912 ↓ 1.0 2,210,560 1 / 3

Bitmap Index Scan on ix_checks_test (cost=0.00..49.08 rows=2,129,712 width=0) (actual time=8.736..8.737 rows=2,210,560 loops=1)

  • Index Cond: ((business_date >= '2020-01-01'::date) AND (business_date <= '2020-06-01'::date))