explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KQwV

Settings
# exclusive inclusive rows x rows loops node
1. 29.680 10,819.359 ↑ 4.5 213,199 1

Gather (cost=5,112.85..1,322,757.34 rows=968,827 width=34) (actual time=67.237..10,819.359 rows=213,199 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 211.693 10,789.679 ↑ 5.7 71,066 3 / 3

Hash Join (cost=4,112.85..1,224,874.64 rows=403,678 width=34) (actual time=100.545..10,789.679 rows=71,066 loops=3)

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

Parallel Seq Scan on sp_ts_price b (cost=0.00..1,209,118.30 rows=2,028,455 width=34) (actual time=0.719..10,490.358 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. 0.337 87.628 ↑ 4.4 1,101 3 / 3

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

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

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

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

7. 0.342 79.000 ↑ 4.4 1,101 3 / 3

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

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

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

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

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

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

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

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

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

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