explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dAhD

Settings
# exclusive inclusive rows x rows loops node
1. 14.986 5,160.170 ↑ 42,334.9 36 1

Hash Left Join (cost=249,731.98..509,170.64 rows=1,524,056 width=224) (actual time=3,492.975..5,160.170 rows=36 loops=1)

  • Hash Cond: (v.address_id = a.id)
2. 0.041 3,677.446 ↑ 42,334.9 36 1

Hash Join (cost=124,901.23..380,339.24 rows=1,524,056 width=165) (actual time=2,010.299..3,677.446 rows=36 loops=1)

  • Hash Cond: (e.data_source_id = ds.id)
3. 694.174 3,677.390 ↑ 42,334.9 36 1

Hash Join (cost=124,867.16..376,288.67 rows=1,524,056 width=133) (actual time=2,010.275..3,677.390 rows=36 loops=1)

  • Hash Cond: (v.id = cvp.place_description_version_id)
4. 1,050.562 1,050.562 ↓ 1.0 4,724,896 1

Seq Scan on place_description_version v (cost=0.00..212,556.97 rows=4,724,797 width=68) (actual time=0.003..1,050.562 rows=4,724,896 loops=1)

5. 0.019 1,932.654 ↑ 42,334.9 36 1

Hash (cost=105,816.46..105,816.46 rows=1,524,056 width=81) (actual time=1,932.654..1,932.654 rows=36 loops=1)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 16,388kB
6. 14.432 1,932.635 ↑ 42,334.9 36 1

Hash Join (cost=100,403.70..105,816.46 rows=1,524,056 width=81) (actual time=1,932.437..1,932.635 rows=36 loops=1)

  • Hash Cond: (e.id = cvp.place_description_id)
7. 0.037 783.530 ↑ 42,274.5 36 1

Nested Loop (cost=13.18..1,431.00 rows=1,521,881 width=81) (actual time=783.354..783.530 rows=36 loops=1)

8. 0.027 783.349 ↑ 5.6 36 1

HashAggregate (cost=12.75..14.75 rows=200 width=8) (actual time=783.338..783.349 rows=36 loops=1)

  • Group Key: find_all_related_place_descriptions_by_geocode.id
9. 783.322 783.322 ↑ 27.8 36 1

Function Scan on find_all_related_place_descriptions_by_geocode (cost=0.25..10.25 rows=1,000 width=8) (actual time=783.320..783.322 rows=36 loops=1)

10. 0.144 0.144 ↑ 1.0 1 36

Index Scan using place_description_pkey on place_description e (cost=0.43..8.41 rows=1 width=73) (actual time=0.004..0.004 rows=1 loops=36)

  • Index Cond: (id = find_all_related_place_descriptions_by_geocode.id)
11. 714.201 1,134.673 ↑ 1.0 3,048,112 1

Hash (cost=62,289.12..62,289.12 rows=3,048,112 width=16) (actual time=1,134.673..1,134.673 rows=3,048,112 loops=1)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 175,649kB
12. 420.472 420.472 ↑ 1.0 3,048,112 1

Seq Scan on place_description_current_version_pointer cvp (cost=0.00..62,289.12 rows=3,048,112 width=16) (actual time=0.015..420.472 rows=3,048,112 loops=1)

13. 0.008 0.015 ↑ 76.4 14 1

Hash (cost=20.70..20.70 rows=1,070 width=40) (actual time=0.015..0.015 rows=14 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
14. 0.007 0.007 ↑ 76.4 14 1

Seq Scan on data_source ds (cost=0.00..20.70 rows=1,070 width=40) (actual time=0.005..0.007 rows=14 loops=1)

15. 899.909 1,467.738 ↑ 1.0 2,635,811 1

Hash (cost=91,883.11..91,883.11 rows=2,635,811 width=59) (actual time=1,467.738..1,467.738 rows=2,635,811 loops=1)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 251,199kB
16. 567.829 567.829 ↑ 1.0 2,635,811 1

Seq Scan on address a (cost=0.00..91,883.11 rows=2,635,811 width=59) (actual time=0.012..567.829 rows=2,635,811 loops=1)

Planning time : 1.312 ms
Execution time : 5,184.325 ms