explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gzKO

Settings
# exclusive inclusive rows x rows loops node
1. 0.558 176,241.330 ↑ 4.0 1,000 1

Subquery Scan on c (cost=6,236,040.61..6,236,434.70 rows=4,042 width=32) (actual time=176,232.335..176,241.330 rows=1,000 loops=1)

  • Filter: (c.rank <= 1,000)
  • Rows Removed by Filter: 9,130
2. 7.316 176,240.772 ↑ 1.2 10,130 1

WindowAgg (cost=6,236,040.61..6,236,283.13 rows=12,126 width=40) (actual time=176,232.333..176,240.772 rows=10,130 loops=1)

3. 15.068 176,233.456 ↑ 1.2 10,130 1

Sort (cost=6,236,040.61..6,236,070.92 rows=12,126 width=24) (actual time=176,232.320..176,233.456 rows=10,130 loops=1)

  • Sort Key: ft_fundamental.value DESC
  • Sort Method: quicksort Memory: 1,176kB
4. 15.495 176,218.388 ↑ 1.2 10,130 1

Nested Loop (cost=1,001.14..6,235,218.11 rows=12,126 width=24) (actual time=38.560..176,218.388 rows=10,130 loops=1)

5. 0.000 176,058.461 ↑ 1.1 24,072 1

Gather (cost=1,000.58..6,214,411.86 rows=26,618 width=16) (actual time=35.194..176,058.461 rows=24,072 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 176,155.656 176,155.656 ↑ 1.4 8,024 3 / 3

Parallel Index Scan using ft_security_data_idx_id_covering on ft_security_data ft_fundamental (cost=0.58..6,210,750.06 rows=11,091 width=16) (actual time=16.245..176,155.656 rows=8,024 loops=3)

  • Index Cond: (m_data_field_id = 28)
  • Filter: ((value IS NOT NULL) AND (from_to @> '2020-05-20 00:00:00'::timestamp without time zone) AND (provider_id = 1))
  • Rows Removed by Filter: 19,255,964
7. 24.072 144.432 ↓ 0.0 0 24,072

Append (cost=0.56..0.77 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=24,072)

8. 120.360 120.360 ↓ 0.0 0 24,072

Index Only Scan using its_universe_component_06_pkey on its_universe_component_06 u (cost=0.56..0.77 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=24,072)

  • Index Cond: (("timestamp" = '2020-07-16 00:00:00'::timestamp without time zone) AND (m_universe_id = 1,140) AND (m_security_id = ft_fundamental.security_id))
  • Heap Fetches: 10,130