explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W7cv

Settings
# exclusive inclusive rows x rows loops node
1. 832.015 902.074 ↑ 1.0 65,468 1

Hash Join (cost=1,301.59..7,386.99 rows=65,468 width=459) (actual time=15.024..902.074 rows=65,468 loops=1)

  • Hash Cond: (p2loc.geo_location_id = loc.geo_location_id)
  • Buffers: shared hit=20,535
2. 23.561 55.524 ↑ 1.0 65,468 1

Merge Join (cost=19.95..5,041.50 rows=65,468 width=443) (actual time=0.240..55.524 rows=65,468 loops=1)

  • Merge Cond: ((p.proj_id)::text = (p2loc.proj_id)::text)
  • Buffers: shared hit=19,183
3. 21.235 21.235 ↑ 1.0 18,838 1

Index Scan using project_pkey on project p (cost=0.29..1,881.62 rows=18,838 width=432) (actual time=0.009..21.235 rows=18,838 loops=1)

  • Buffers: shared hit=18,857
4. 10.728 10.728 ↑ 1.0 65,468 1

Index Only Scan using index_project2location on project2location p2loc (cost=0.41..2,294.44 rows=65,468 width=19) (actual time=0.014..10.728 rows=65,468 loops=1)

  • Heap Fetches: 0
  • Buffers: shared hit=326
5. 7.820 14.535 ↑ 1.0 31,095 1

Hash (cost=892.95..892.95 rows=31,095 width=38) (actual time=14.535..14.535 rows=31,095 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,405kB
  • Buffers: shared hit=582
6. 6.715 6.715 ↑ 1.0 31,095 1

Seq Scan on project_location loc (cost=0.00..892.95 rows=31,095 width=38) (actual time=0.005..6.715 rows=31,095 loops=1)

  • Buffers: shared hit=582