explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IkVf

Settings
# exclusive inclusive rows x rows loops node
1. 6.061 2,809.889 ↑ 1.0 15 1

Unique (cost=33,222.85..33,233.35 rows=15 width=2) (actual time=2,798.275..2,809.889 rows=15 loops=1)

2. 41.207 2,803.828 ↓ 25.0 52,490 1

Sort (cost=33,222.85..33,228.10 rows=2,099 width=2) (actual time=2,798.272..2,803.828 rows=52,490 loops=1)

  • Sort Key: partitioned_flows_1.year
  • Sort Method: quicksort Memory: 3826kB
3. 44.183 2,762.621 ↓ 25.0 52,490 1

Gather (cost=1,000.43..33,107.03 rows=2,099 width=2) (actual time=2.044..2,762.621 rows=52,490 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,541.757 2,718.438 ↓ 20.0 17,497 3

Nested Loop (cost=0.43..31,897.13 rows=875 width=2) (actual time=0.588..2,718.438 rows=17,497 loops=3)

5. 176.537 176.537 ↓ 19.9 17,497 3

Parallel Seq Scan on partitioned_flows_1 (cost=0.00..7,865.45 rows=881 width=10) (actual time=0.318..176.537 rows=17,497 loops=3)

  • Filter: ((context_id = 1) AND (path[6] = 29138))
  • Rows Removed by Filter: 123487
6. 0.144 0.144 ↑ 1.0 1 52,490

Index Scan using index_partitioned_flow_quants_1_on_flow_id on partitioned_flow_quants_1 (cost=0.43..27.27 rows=1 width=4) (actual time=0.132..0.144 rows=1 loops=52,490)

  • Index Cond: (flow_id = partitioned_flows_1.id)
  • Filter: (quant_id = 1)
  • Rows Removed by Filter: 7