explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5BAS

Settings
# exclusive inclusive rows x rows loops node
1. 18.505 296.923 ↓ 15.4 66,085 1

Hash Join (cost=8,501.31..101,196.15 rows=4,289 width=112) (actual time=22.081..296.923 rows=66,085 loops=1)

  • Hash Cond: (v.value = s.value)
2. 0.000 278.396 ↓ 62.4 66,085 1

Nested Loop (cost=8,473.08..101,015.16 rows=1,059 width=48) (actual time=22.048..278.396 rows=66,085 loops=1)

3. 30.785 152.004 ↓ 62.4 66,085 1

Hash Join (cost=8,472.79..100,676.47 rows=1,059 width=48) (actual time=22.030..152.004 rows=66,085 loops=1)

  • Hash Cond: (v.impact_indicator_type_id = t.id)
4. 34.700 121.208 ↓ 1.2 272,522 1

Nested Loop (cost=8,452.12..100,062.24 rows=224,991 width=20) (actual time=22.005..121.208 rows=272,522 loops=1)

5. 0.004 0.036 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.83 rows=1 width=12) (actual time=0.021..0.036 rows=1 loops=1)

  • Join Filter: (i.id = d.impact_indicator_id)
  • Rows Removed by Join Filter: 2
6. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on impact_indicator i (cost=0.00..1.03 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: (active IS TRUE)
  • Rows Removed by Filter: 2
7. 0.027 0.027 ↓ 3.0 3 1

Seq Scan on impact_indicator_day d (cost=0.00..1.79 rows=1 width=12) (actual time=0.014..0.027 rows=3 loops=1)

  • Filter: ((valid_at)::text = '2020-02-13'::text)
  • Rows Removed by Filter: 42
8. 67.634 86.472 ↓ 1.2 272,522 1

Bitmap Heap Scan on impact_indicator_value v (cost=8,452.12..97,809.50 rows=224,991 width=16) (actual time=21.978..86.472 rows=272,522 loops=1)

  • Recheck Cond: (impact_indicator_day_id = d.id)
  • Heap Blocks: exact=19981
9. 18.838 18.838 ↓ 1.2 272,522 1

Bitmap Index Scan on impact_indicator_value_impact_indicator_day_id_idx (cost=0.00..8,395.87 rows=224,991 width=0) (actual time=18.838..18.838 rows=272,522 loops=1)

  • Index Cond: (impact_indicator_day_id = d.id)
10. 0.002 0.011 ↑ 4.0 1 1

Hash (cost=20.62..20.62 rows=4 width=36) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.009 0.009 ↑ 4.0 1 1

Seq Scan on impact_indicator_type t (cost=0.00..20.62 rows=4 width=36) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (name = 'overall'::text)
  • Rows Removed by Filter: 7
12. 132.170 132.170 ↑ 1.0 1 66,085

Index Only Scan using impact_indicator_area_pkey on impact_indicator_area a (cost=0.29..0.32 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=66,085)

  • Index Cond: (id = v.impact_indicator_area_id)
  • Heap Fetches: 66085
13. 0.009 0.022 ↑ 81.0 10 1

Hash (cost=18.10..18.10 rows=810 width=68) (actual time=0.022..0.022 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.013 0.013 ↑ 81.0 10 1

Seq Scan on impact_indicator_style s (cost=0.00..18.10 rows=810 width=68) (actual time=0.008..0.013 rows=10 loops=1)

Planning time : 2.118 ms
Execution time : 300.768 ms