explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GX9s

Settings
# exclusive inclusive rows x rows loops node
1. 0.525 657.173 ↓ 23.0 3,376 1

Nested Loop (cost=3,568.35..102,577.75 rows=147 width=53) (actual time=315.327..657.173 rows=3,376 loops=1)

2.          

CTE timestamps

3. 0.005 0.005 ↑ 1.0 6 1

Values Scan on "*VALUES*" (cost=0.00..0.08 rows=6 width=8) (actual time=0.003..0.005 rows=6 loops=1)

4. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on m_data_field b (cost=0.00..3.56 rows=1 width=22) (actual time=0.009..0.023 rows=1 loops=1)

  • Filter: (id = 2)
  • Rows Removed by Filter: 153
5. 253.857 656.625 ↓ 23.0 3,376 1

Nested Loop Semi Join (cost=3,568.27..102,572.65 rows=147 width=39) (actual time=315.317..656.625 rows=3,376 loops=1)

  • Join Filter: (a.from_to @> timestamps.ts)
  • Rows Removed by Join Filter: 654744
  • -> CTE Scan on timestamps (cost=0.00..0.12 rows=6 width=8) (actual time=0.000..0.001 rows=6 loops=111393)"Planning Time: 0.212 ms
6. 0.000 402.768 ↑ 1.3 111,393 1

Gather (cost=3,568.27..82,737.17 rows=147,034 width=39) (actual time=315.301..402.768 rows=111,393 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 64.197 483.510 ↑ 1.6 37,131 3 / 3

Hash Join (cost=2,568.27..67,033.77 rows=61,264 width=39) (actual time=304.230..483.510 rows=37,131 loops=3)

  • Hash Cond: (a.security_id = its_universe_component.m_security_id)
8. 361.415 361.415 ↑ 1.2 325,810 3 / 3

Parallel Seq Scan on ft_security_data a (cost=0.00..63,401.56 rows=405,233 width=39) (actual time=246.261..361.415 rows=325,810 loops=3)

  • Filter: (m_data_field_id = 2)
  • Rows Removed by Filter: 911792
9. 0.225 57.898 ↑ 3.1 1,101 3 / 3

Hash (cost=2,525.60..2,525.60 rows=3,414 width=8) (actual time=57.898..57.898 rows=1,101 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 76kB
10. 28.355 57.673 ↑ 3.1 1,101 3 / 3

HashAggregate (cost=2,457.32..2,491.46 rows=3,414 width=8) (actual time=57.489..57.673 rows=1,101 loops=3)

  • Group Key: its_universe_component.m_security_id
11. 29.318 29.318 ↓ 1.0 95,577 3 / 3

Seq Scan on its_universe_component (cost=0.00..2,218.46 rows=95,542 width=8) (actual time=0.989..29.318 rows=95,577 loops=3)

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