explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SrQy

Settings
# exclusive inclusive rows x rows loops node
1. 1,201.566 57,489.852 ↑ 4.6 213,199 1

Gather (cost=5,112.85..1,323,575.51 rows=970,420 width=34) (actual time=363.632..57,489.852 rows=213,199 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1,020.696 56,288.286 ↑ 5.7 71,066 3 / 3

Hash Join (cost=4,112.85..1,225,533.51 rows=404,342 width=34) (actual time=1,008.138..56,288.286 rows=71,066 loops=3)

  • Hash Cond: (b.quote_id = a.id)
3. 54,317.482 54,317.482 ↑ 1.3 1,553,336 3 / 3

Parallel Seq Scan on sp_ts_price b (cost=0.00..1,209,758.02 rows=2,031,790 width=34) (actual time=0.061..54,317.482 rows=1,553,336 loops=3)

  • Filter: ((price_date >= '2019-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: 19448333
4. 5.228 950.108 ↑ 4.4 1,101 3 / 3

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

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

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

  • Hash Cond: (c.id = a.security_id)
6. 91.427 91.427 ↑ 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.571..91.427 rows=24,505 loops=3)

7. 0.473 820.023 ↑ 4.4 1,101 3 / 3

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

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

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

  • Hash Cond: (a.security_id = its_universe_component.m_security_id)
9. 21.567 21.567 ↑ 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.013..21.567 rows=24,505 loops=3)

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

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

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

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

  • Group Key: its_universe_component.m_security_id
12. 295.250 295.250 ↑ 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=14.303..295.250 rows=95,577 loops=3)

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