explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3GG

Settings
# exclusive inclusive rows x rows loops node
1. 122.246 254.916 ↑ 1.0 33,504 1

Gather (cost=1,000.14..10,475.54 rows=33,506 width=167) (actual time=1.093..254.916 rows=33,504 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 0.896 132.670 ↑ 1.3 8,376 4 / 4

Parallel Append (cost=0.14..6,124.94 rows=10,810 width=167) (actual time=19.538..132.670 rows=8,376 loops=4)

3. 130.677 130.677 ↑ 2.4 6,379 4 / 4

Parallel Index Scan using road_network_partitioned_755_link_id_idx on road_network_partitioned_755 (cost=0.29..3,811.03 rows=15,009 width=160) (actual time=19.537..130.677 rows=6,379 loops=4)

  • Index Cond: ((link_id > '754000000000000000'::bigint) AND (link_id < '758000000000000000'::bigint))
4. 1.095 1.095 ↓ 1.7 7,988 1 / 4

Parallel Index Scan using road_network_partitioned_754_link_id_idx on road_network_partitioned_754 (cost=0.28..1,228.39 rows=4,699 width=193) (actual time=0.016..4.378 rows=7,988 loops=1)

  • Index Cond: ((link_id > '754000000000000000'::bigint) AND (link_id < '758000000000000000'::bigint))
5. 0.000 0.000 ↓ 0.0 0 1 / 4

Parallel Index Scan using road_network_partitioned_756_link_id_idx on road_network_partitioned_756 (cost=0.14..2.26 rows=1 width=1,330) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((link_id > '754000000000000000'::bigint) AND (link_id < '758000000000000000'::bigint))
6. 0.002 0.002 ↓ 0.0 0 1 / 4

Parallel Index Scan using road_network_partitioned_757_link_id_idx on road_network_partitioned_757 (cost=0.14..2.26 rows=1 width=1,330) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((link_id > '754000000000000000'::bigint) AND (link_id < '758000000000000000'::bigint))