explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gCjVy

Settings
# exclusive inclusive rows x rows loops node
1. 153.996 10,688.927 ↑ 1.0 1 1

Limit (cost=15,210,714.82..15,210,714.83 rows=1 width=8) (actual time=10,688.926..10,688.927 rows=1 loops=1)

  • Functions: 42
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4.879 ms, Inlining 162.965 ms, Optimization 289.849 ms, Emission 202.949 ms, Total 660.643 ms
2. 0.000 10,534.931 ↑ 1.0 1 1

Finalize Aggregate (cost=15,210,714.82..15,210,714.83 rows=1 width=8) (actual time=10,534.931..10,534.931 rows=1 loops=1)

3. 46.930 10,535.128 ↓ 1.5 3 1

Gather (cost=15,210,714.61..15,210,714.82 rows=2 width=8) (actual time=10,528.130..10,535.128 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.012 10,488.198 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=15,209,714.61..15,209,714.62 rows=1 width=8) (actual time=10,488.198..10,488.198 rows=1 loops=3)

5. 0.235 10,488.186 ↓ 0.0 0 3 / 3

Parallel Hash Join (cost=7,135,039.69..15,206,622.13 rows=1,236,992 width=0) (actual time=10,488.184..10,488.186 rows=0 loops=3)

  • Hash Cond: (road_segments.link_id = road_network.link_id)
6. 0.000 0.000 ↓ 0.0 0 / 3

Parallel Seq Scan on road_segments (cost=0.00..7,422,144.00 rows=247,404,800 width=8) (never executed)

7. 0.562 10,487.951 ↓ 0.0 0 3 / 3

Parallel Hash (cost=7,134,953.92..7,134,953.92 rows=6,862 width=8) (actual time=10,487.951..10,487.951 rows=0 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 0kB
8. 10,487.389 10,487.389 ↓ 0.0 0 3 / 3

Parallel Seq Scan on road_network (cost=0.00..7,134,953.92 rows=6,862 width=8) (actual time=10,487.388..10,487.389 rows=0 loops=3)

  • Filter: (((LEAST(((abs(LEAST((st_y(st_centroid(geom)) - '-10'::double precision), '0'::double precision)) / '1'::double precision))::integer, 33) * 42) + LEAST(((GREATEST((st_x(st_centroid(geom)) - '112'::double precision), '0'::double precision) / '1'::double precision))::integer, 41)) = 505)
  • Rows Removed by Filter: 1097961
Planning time : 0.545 ms