explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fFOv

Settings
# exclusive inclusive rows x rows loops node
1. 5.590 1,537.861 ↑ 1.0 15 1

Unique (cost=53,131.04..53,141.59 rows=15 width=2) (actual time=1,527.774..1,537.861 rows=15 loops=1)

2. 24.237 1,532.271 ↓ 24.9 52,490 1

Sort (cost=53,131.04..53,136.32 rows=2,110 width=2) (actual time=1,527.772..1,532.271 rows=52,490 loops=1)

  • Sort Key: partitioned_flows_1.year
  • Sort Method: quicksort Memory: 3826kB
3. 24.258 1,508.034 ↓ 24.9 52,490 1

Gather (cost=12,592.72..53,014.54 rows=2,110 width=2) (actual time=258.444..1,508.034 rows=52,490 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 67.564 1,483.776 ↓ 19.9 17,497 3

Hash Join (cost=11,592.72..51,803.54 rows=879 width=2) (actual time=246.631..1,483.776 rows=17,497 loops=3)

  • Hash Cond: (partitioned_flow_quants_1.flow_id = partitioned_flows_1.id)
5. 1,171.885 1,171.885 ↑ 1.2 140,984 3

Parallel Seq Scan on partitioned_flow_quants_1 (cost=0.00..39,542.76 rows=175,806 width=4) (actual time=0.860..1,171.885 rows=140,984 loops=3)

  • Filter: (quant_id = 1)
  • Rows Removed by Filter: 908345
6. 23.206 244.327 ↓ 24.8 52,490 3

Hash (cost=11,566.28..11,566.28 rows=2,115 width=10) (actual time=244.327..244.327 rows=52,490 loops=3)

  • Buckets: 65536 (originally 4096) Batches: 1 (originally 1) Memory Usage: 2973kB
7. 221.121 221.121 ↓ 24.8 52,490 3

Seq Scan on partitioned_flows_1 (cost=0.00..11,566.28 rows=2,115 width=10) (actual time=0.153..221.121 rows=52,490 loops=3)

  • Filter: ((context_id = 1) AND (path[6] = 29138))
  • Rows Removed by Filter: 370462