explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V2wE

Settings
# exclusive inclusive rows x rows loops node
1. 74.022 11,745.909 ↑ 4.3 637,213 1

Gather (cost=5,112.85..1,519,845.69 rows=2,728,238 width=34) (actual time=67.308..11,745.909 rows=637,213 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 623.801 11,671.887 ↑ 5.4 212,404 3 / 3

Hash Join (cost=4,112.85..1,246,021.89 rows=1,136,766 width=34) (actual time=99.471..11,671.887 rows=212,404 loops=3)

  • Hash Cond: (b.quote_id = a.id)
3. 10,963.955 10,963.955 ↑ 1.2 4,573,858 3 / 3

Parallel Seq Scan on sp_ts_price b (cost=0.00..1,209,118.30 rows=5,712,821 width=34) (actual time=0.747..10,963.955 rows=4,573,858 loops=3)

  • Filter: ((price_date >= '2017-01-13 00:00:00'::timestamp without time zone) AND (price_date <= '2020-01-23 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 16427811
4. 0.318 84.131 ↑ 4.4 1,101 3 / 3

Hash (cost=4,051.92..4,051.92 rows=4,875 width=12) (actual time=84.131..84.131 rows=1,101 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 112kB
5. 3.813 83.813 ↑ 4.4 1,101 3 / 3

Hash Join (cost=3,346.22..4,051.92 rows=4,875 width=12) (actual time=76.771..83.813 rows=1,101 loops=3)

  • Hash Cond: (c.id = a.security_id)
6. 3.271 3.271 ↑ 1.0 24,505 3 / 3

Seq Scan on m_security c (cost=0.00..565.05 rows=24,505 width=8) (actual time=0.008..3.271 rows=24,505 loops=3)

7. 0.337 76.729 ↑ 4.4 1,101 3 / 3

Hash (cost=3,285.28..3,285.28 rows=4,875 width=20) (actual time=76.729..76.729 rows=1,101 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 125kB
8. 3.657 76.392 ↑ 4.4 1,101 3 / 3

Hash Join (cost=2,709.64..3,285.28 rows=4,875 width=20) (actual time=67.709..76.392 rows=1,101 loops=3)

  • Hash Cond: (a.security_id = its_universe_component.m_security_id)
9. 6.615 6.615 ↑ 1.0 24,505 3 / 3

Seq Scan on i_quote a (cost=0.00..511.31 rows=24,505 width=12) (actual time=0.009..6.615 rows=24,505 loops=3)

  • Filter: (primary_exchange = 1)
10. 0.288 66.120 ↑ 4.4 1,101 3 / 3

Hash (cost=2,648.70..2,648.70 rows=4,875 width=8) (actual time=66.119..66.120 rows=1,101 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 108kB
11. 36.806 65.832 ↑ 4.4 1,101 3 / 3

HashAggregate (cost=2,551.20..2,599.95 rows=4,875 width=8) (actual time=65.591..65.832 rows=1,101 loops=3)

  • Group Key: its_universe_component.m_security_id
12. 29.026 29.026 ↑ 1.0 95,577 3 / 3

Seq Scan on its_universe_component (cost=0.00..2,312.21 rows=95,594 width=8) (actual time=1.603..29.026 rows=95,577 loops=3)

  • Filter: (m_universe_id = 106)" Rows Removed by Filter: 15000