explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ig7l

Settings
# exclusive inclusive rows x rows loops node
1. 274.353 6,582.766 ↑ 1.6 783,622 1

Unique (cost=701,667.98..716,983.25 rows=1,225,222 width=76) (actual time=5,927.563..6,582.766 rows=783,622 loops=1)

  • Buffers: shared hit=720 read=174,472, temp read=65,956 written=67,875
2. 1,172.964 6,308.413 ↑ 1.2 1,035,404 1

Sort (cost=701,667.98..704,731.03 rows=1,225,222 width=76) (actual time=5,927.561..6,308.413 rows=1,035,404 loops=1)

  • Sort Key: ci.geoname_id, acn.city_term, ci.country_code, ci.population
  • Sort Method: external merge Disk: 44,344kB
  • Buffers: shared hit=720 read=174,472, temp read=65,956 written=67,875
3. 123.777 5,135.449 ↑ 1.2 1,035,404 1

Append (cost=307,948.9..468,884.78 rows=1,225,222 width=76) (actual time=3,907.489..5,135.449 rows=1,035,404 loops=1)

  • Buffers: shared hit=720 read=174,472, temp read=57,572 written=59,464
4. 348.371 5,011.620 ↑ 1.2 1,035,294 1

Hash Join (cost=307,948.9..450,504.35 rows=1,225,112 width=29) (actual time=3,907.488..5,011.62 rows=1,035,294 loops=1)

  • Buffers: shared hit=719 read=174,472, temp read=57,572 written=59,464
5. 56.637 4,152.784 ↑ 1.0 807,348 1

Gather (cost=307,936.28..430,167.14 rows=807,348 width=29) (actual time=3,397.006..4,152.784 rows=807,348 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=715 read=174,472, temp read=57,572 written=59,464
6. 923.212 4,096.147 ↑ 1.2 269,116 3 / 3

Hash Join (cost=306,936.28..348,432.34 rows=336,395 width=29) (actual time=3,330.641..4,096.147 rows=269,116 loops=3)

  • Buffers: shared hit=715 read=174,472, temp read=57,572 written=59,464
7. 69.069 69.069 ↑ 1.2 269,116 3 / 3

Seq Scan on geo_lookup_alternate_city_name acn (cost=0..8,731.95 rows=336,395 width=19) (actual time=0.132..69.069 rows=269,116 loops=3)

  • Buffers: shared hit=385 read=4,983
8. 1,596.617 3,103.866 ↑ 1.3 4,007,984 3 / 3

Hash (cost=219,805.57..219,805.57 rows=5,012,457 width=14) (actual time=3,103.865..3,103.866 rows=4,007,984 loops=3)

  • Buffers: shared hit=192 read=169,489, temp written=53,780
9. 1,507.249 1,507.249 ↑ 1.3 4,007,984 3 / 3

Seq Scan on pm_lookup_location_geoname_city_info ci (cost=0..219,805.57 rows=5,012,457 width=14) (actual time=229.693..1,507.249 rows=4,007,984 loops=3)

  • Buffers: shared hit=192 read=169,489
10. 0.265 510.465 ↑ 1.0 383 1

Hash (cost=7.83..7.83 rows=383 width=3) (actual time=510.464..510.465 rows=383 loops=1)

  • Buffers: shared hit=4
11. 510.200 510.200 ↑ 1.0 383 1

Seq Scan on geo_lookup_location_country_language_iso lang (cost=0..7.83 rows=383 width=3) (actual time=510.013..510.2 rows=383 loops=1)

  • Buffers: shared hit=4
12. 0.052 0.052 ↑ 1.0 110 1

Seq Scan on pm_xref_fusion_airtable_city_term pm_xref_fusion_airtable_city_term (cost=0..2.1 rows=110 width=26) (actual time=0.037..0.052 rows=110 loops=1)

  • Buffers: shared hit=1
Planning time : 1.051 ms
Execution time : 6,641.471 ms