explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ttc3

Settings
# exclusive inclusive rows x rows loops node
1. 4.795 1,398.847 ↓ 1.4 15 1

Unique (cost=4,486.80..4,486.86 rows=11 width=2) (actual time=1,390.254..1,398.847 rows=15 loops=1)

2. 26.787 1,394.052 ↓ 4,037.7 52,490 1

Sort (cost=4,486.80..4,486.83 rows=13 width=2) (actual time=1,390.253..1,394.052 rows=52,490 loops=1)

  • Sort Key: partitioned_flows_1.year
  • Sort Method: quicksort Memory: 3826kB
3. 36.851 1,367.265 ↓ 4,037.7 52,490 1

Nested Loop (cost=40.72..4,486.56 rows=13 width=2) (actual time=56.784..1,367.265 rows=52,490 loops=1)

4. 173.748 228.124 ↓ 4,771.8 52,490 1

Bitmap Heap Scan on partitioned_flows_1 (cost=40.29..4,045.33 rows=11 width=10) (actual time=55.455..228.124 rows=52,490 loops=1)

  • Recheck Cond: (context_id = 1)
  • Filter: (path[6] = 29138)
  • Rows Removed by Filter: 370462
  • Heap Blocks: exact=5222
5. 54.376 54.376 ↓ 200.0 422,952 1

Bitmap Index Scan on index_partitioned_flows_1_on_context_id (cost=0.00..40.28 rows=2,115 width=0) (actual time=54.376..54.376 rows=422,952 loops=1)

  • Index Cond: (context_id = 1)
6. 1,102.290 1,102.290 ↑ 1.0 1 52,490

Index Scan using index_partitioned_flow_quants_1_on_flow_id on partitioned_flow_quants_1 (cost=0.43..40.10 rows=1 width=4) (actual time=0.018..0.021 rows=1 loops=52,490)

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