explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DJxN

Settings
# exclusive inclusive rows x rows loops node
1. 3.464 3,681.090 ↑ 1.0 22,402 1

Hash Join (cost=343,536.07..344,208.77 rows=23,029 width=23) (actual time=3,660.495..3,681.090 rows=22,402 loops=1)

  • Hash Cond: (c.country_id = d.id)
2. 3.867 3,677.497 ↑ 1.0 22,402 1

Hash Join (cost=343,530.59..344,141.35 rows=23,029 width=17) (actual time=3,660.359..3,677.497 rows=22,402 loops=1)

  • Hash Cond: (a.exchange_id = c.id)
3. 5.297 3,673.549 ↑ 1.0 22,402 1

Hash Join (cost=343,527.59..344,075.14 rows=23,029 width=12) (actual time=3,660.271..3,673.549 rows=22,402 loops=1)

  • Hash Cond: (a.security_id = its_universe_component.m_security_id)
4. 8.026 8.026 ↑ 1.0 24,491 1

Index Only Scan using i_quote_security_idx_id_covering on i_quote a (cost=0.29..483.54 rows=24,491 width=12) (actual time=0.010..8.026 rows=24,491 loops=1)

  • Filter: (primary_exchange = 1)
  • Heap Fetches: 21,537
5. 2.812 3,660.226 ↑ 1.0 22,410 1

Hash (cost=343,239.44..343,239.44 rows=23,029 width=8) (actual time=3,660.226..3,660.226 rows=22,410 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,132kB
6. 2,232.318 3,657.414 ↑ 1.0 22,410 1

HashAggregate (cost=342,778.86..343,009.15 rows=23,029 width=8) (actual time=3,654.518..3,657.414 rows=22,410 loops=1)

  • Group Key: its_universe_component.m_security_id
7. 1,425.096 1,425.096 ↑ 1.0 15,636,110 1

Index Only Scan using its_universe_component_idx_universe_id_covering on its_universe_component (cost=0.44..302,238.76 rows=16,216,041 width=8) (actual time=0.041..1,425.096 rows=15,636,110 loops=1)

  • Index Cond: (m_universe_id = 179)
  • Heap Fetches: 0
8. 0.023 0.081 ↑ 1.0 92 1

Hash (cost=1.84..1.84 rows=93 width=13) (actual time=0.081..0.081 rows=92 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
9. 0.058 0.058 ↑ 1.0 92 1

Index Scan using m_exchange_pkey on m_exchange c (cost=0.14..1.84 rows=93 width=13) (actual time=0.007..0.058 rows=92 loops=1)

10. 0.051 0.129 ↓ 1.0 173 1

Hash (cost=3.32..3.32 rows=172 width=14) (actual time=0.129..0.129 rows=173 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
11. 0.078 0.078 ↓ 1.0 173 1

Index Scan using m_country_pkey on m_country d (cost=0.14..3.32 rows=172 width=14) (actual time=0.010..0.078 rows=173 loops=1)