explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NBw7

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 8,469.885 ↑ 1.0 10 1

Limit (cost=384,571.49..384,571.85 rows=10 width=4,708) (actual time=8,469.868..8,469.885 rows=10 loops=1)

2. 0.011 8,469.881 ↑ 150,665.2 10 1

Nested Loop (cost=384,571.49..438,065.49 rows=1,506,652 width=4,708) (actual time=8,469.866..8,469.881 rows=10 loops=1)

3. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on administrations_2018 ad (cost=0.00..761.17 rows=1 width=4,610) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: ((name)::text = 'Freiburg im Breisgau'::text)
  • Rows Removed by Filter: 8
4. 0.008 8,469.855 ↑ 150,665.2 10 1

Unique (cost=384,571.49..407,171.27 rows=1,506,652 width=98) (actual time=8,469.845..8,469.855 rows=10 loops=1)

5. 6,584.784 8,469.847 ↑ 150,665.2 10 1

Sort (cost=384,571.49..388,338.12 rows=1,506,652 width=98) (actual time=8,469.842..8,469.847 rows=10 loops=1)

  • Sort Key: fr.id, fr.geom, fr.cellcode, fr.eoforigin, fr.noforigin
  • Sort Method: external sort Disk: 256,528kB
6. 224.556 1,885.063 ↑ 1.0 1,506,652 1

Append (cost=0.00..65,173.04 rows=1,506,652 width=98) (actual time=0.333..1,885.063 rows=1,506,652 loops=1)

7. 1,062.236 1,062.236 ↑ 1.0 967,881 1

Seq Scan on france_1km fr (cost=0.00..32,187.81 rows=967,881 width=162) (actual time=0.333..1,062.236 rows=967,881 loops=1)

8. 25.033 25.033 ↑ 1.0 62,102 1

Seq Scan on switzerland_1km ch (cost=0.00..2,066.02 rows=62,102 width=162) (actual time=0.054..25.033 rows=62,102 loops=1)

9. 573.238 573.238 ↑ 1.0 476,669 1

Seq Scan on germany_1km ger (cost=0.00..15,852.69 rows=476,669 width=162) (actual time=0.357..573.238 rows=476,669 loops=1)

Planning time : 0.325 ms