explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NOxZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 127,302.819 ↑ 1.0 1 1

Finalize Aggregate (cost=99,511.66..99,511.67 rows=1 width=8) (actual time=127,274.338..127,302.819 rows=1 loops=1)

2. 53.650 127,302.784 ↓ 1.5 3 1

Gather (cost=99,511.44..99,511.65 rows=2 width=8) (actual time=127,271.766..127,302.784 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 19,561.786 127,249.134 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=98,511.44..98,511.45 rows=1 width=8) (actual time=127,249.044..127,249.134 rows=1 loops=3)

4. 53,981.476 107,687.348 ↓ 3,149.5 4,087,995 3 / 3

Nested Loop (cost=105.37..98,508.20 rows=1,298 width=0) (actual time=2.163..107,687.348 rows=4,087,995 loops=3)

5. 16,379.109 25,265.943 ↓ 3,162.5 1,672,937 3 / 3

Hash Join (cost=104.94..98,229.35 rows=529 width=4) (actual time=1.674..25,265.943 rows=1,672,937 loops=3)

  • Hash Cond: (h.st_id = l.id)
6. 8,885.840 8,885.840 ↑ 1.2 1,758,956 3 / 3

Parallel Seq Scan on household h (cost=0.00..92,346.95 rows=2,198,695 width=8) (actual time=0.505..8,885.840 rows=1,758,956 loops=3)

7. 0.058 0.994 ↑ 1.0 1 3 / 3

Hash (cost=104.93..104.93 rows=1 width=4) (actual time=0.946..0.994 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.936 0.936 ↑ 1.0 1 3 / 3

Seq Scan on locale l (cost=0.00..104.93 rows=1 width=4) (actual time=0.532..0.936 rows=1 loops=3)

  • Filter: (fips = '42'::text)
  • Rows Removed by Filter: 4,153
9. 28,439.929 28,439.929 ↑ 1.5 2 5,018,811 / 3

Index Only Scan using person__household_id__fk_idx on person p (cost=0.43..0.50 rows=3 width=4) (actual time=0.005..0.017 rows=2 loops=5,018,811)

  • Index Cond: (household_id = h.id)
  • Heap Fetches: 0
Planning time : 38.912 ms
Execution time : 127,302.988 ms