explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k9rG : New_plan

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.325 ↓ 0.0 0 1

Update on spec_households (cost=47,743.95..49,233.25 rows=2,735 width=514) (actual time=0.325..0.325 rows=0 loops=1)

2. 0.001 0.325 ↓ 0.0 0 1

Nested Loop (cost=47,743.95..49,233.25 rows=2,735 width=514) (actual time=0.325..0.325 rows=0 loops=1)

3. 0.004 0.324 ↓ 0.0 0 1

HashAggregate (cost=47,743.52..47,770.87 rows=2,735 width=22) (actual time=0.324..0.324 rows=0 loops=1)

  • Group Key: b.household_folder_id
4. 0.024 0.320 ↓ 0.0 0 1

Hash Join (cost=20,980.19..47,736.69 rows=2,735 width=22) (actual time=0.320..0.320 rows=0 loops=1)

  • Hash Cond: (c.spec_households_id = b.id)
5. 0.099 0.099 ↑ 718,533.0 1 1

Seq Scan on spec_household_panels c (cost=0.00..24,034.65 rows=718,533 width=14) (actual time=0.099..0.099 rows=1 loops=1)

  • Filter: ((household_status_acronym)::text <> ALL ('{MNI,IPQ,PRD,QFM,SUS,OOS}'::text[]))
  • Rows Removed by Filter: 1
6. 0.000 0.197 ↓ 0.0 0 1

Hash (cost=20,948.91..20,948.91 rows=2,502 width=24) (actual time=0.197..0.197 rows=0 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 32kB
7. 0.010 0.197 ↓ 0.0 0 1

Hash Join (cost=187.75..20,948.91 rows=2,502 width=24) (actual time=0.197..0.197 rows=0 loops=1)

  • Hash Cond: (b.specs_id = a.id)
8. 0.090 0.090 ↑ 657,247.0 1 1

Seq Scan on spec_households b (cost=0.00..18,271.47 rows=657,247 width=26) (actual time=0.090..0.090 rows=1 loops=1)

9. 0.000 0.097 ↓ 0.0 0 1

Hash (cost=187.31..187.31 rows=35 width=14) (actual time=0.097..0.097 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
10. 0.002 0.097 ↓ 0.0 0 1

Bitmap Heap Scan on specs a (cost=98.25..187.31 rows=35 width=14) (actual time=0.097..0.097 rows=0 loops=1)

  • Recheck Cond: ((spec_id)::text = ANY ('{1178930,1178931,1178932,1178933,1178935,1178936,1178938,1178940,1178942,1178944,1178945,1178948,1178962,1178964,1178965,1178966,1178967,1178968,1178969,1178970,1178971,1178972,1178973,1178974,1178975,1178976,1178977,1178978,1178979,1178980,1178981,1178982,1178983,1178984,1178985}'::text[]))
11. 0.095 0.095 ↓ 0.0 0 1

Bitmap Index Scan on specs_spec_id_key (cost=0.00..98.24 rows=35 width=0) (actual time=0.095..0.095 rows=0 loops=1)

  • Index Cond: ((spec_id)::text = ANY ('{1178930,1178931,1178932,1178933,1178935,1178936,1178938,1178940,1178942,1178944,1178945,1178948,1178962,1178964,1178965,1178966,1178967,1178968,1178969,1178970,1178971,1178972,1178973,1178974,1178975,1178976,1178977,1178978,1178979,1178980,1178981,1178982,1178983,1178984,1178985}'::text[]))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using spec_households_household_folder_id_unique on spec_households (cost=0.42..0.52 rows=1 width=418) (never executed)

  • Index Cond: (household_folder_id = b.household_folder_id)