explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mg55

Settings
# exclusive inclusive rows x rows loops node
1. 1,450.539 15,034.706 ↓ 51.6 15,632,898 1

Gather (cost=405,604.09..1,524,731.59 rows=302,692 width=24) (actual time=2,938.075..15,034.706 rows=15,632,898 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 10,780.459 13,584.167 ↓ 41.3 5,210,966 3 / 3

Parallel Hash Join (cost=404,604.09..1,493,462.39 rows=126,122 width=24) (actual time=2,901.621..13,584.167 rows=5,210,966 loops=3)

  • Hash Cond: (ft_security_data.security_id = its_universe_component.m_security_id)
  • Join Filter: (ft_security_data.from_to @> its_universe_component."timestamp")
  • Rows Removed by Join Filter: 83,375,456
3. 40.361 40.361 ↑ 1.3 138,805 3 / 3

Parallel Index Only Scan using ft_security_data_idx_id_covering on ft_security_data (cost=0.57..41,843.67 rows=177,000 width=37) (actual time=0.044..40.361 rows=138,805 loops=3)

  • Index Cond: (m_data_field_id = 153)
  • Heap Fetches: 416,415
4. 963.494 2,763.347 ↑ 1.3 5,212,037 3 / 3

Parallel Hash (cost=285,824.30..285,824.30 rows=6,833,137 width=16) (actual time=2,763.347..2,763.347 rows=5,212,037 loops=3)

  • Buckets: 2,097,152 Batches: 16 Memory Usage: 65,312kB
5. 1,799.853 1,799.853 ↑ 1.3 5,212,037 3 / 3

Parallel Seq Scan on its_universe_component (cost=0.00..285,824.30 rows=6,833,137 width=16) (actual time=0.490..1,799.853 rows=5,212,037 loops=3)

  • Filter: (m_universe_id = 179)
  • Rows Removed by Filter: 1,823,613