explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RQCn

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 0.654 ↑ 62.9 36 1

Nested Loop Left Join (cost=35.80..21,759.75 rows=2,263 width=224) (actual time=0.065..0.654 rows=36 loops=1)

2. 0.016 0.511 ↑ 62.9 36 1

Nested Loop (cost=35.37..20,607.65 rows=2,263 width=165) (actual time=0.055..0.511 rows=36 loops=1)

3. 0.010 0.351 ↑ 62.9 36 1

Nested Loop (cost=34.94..19,008.85 rows=2,263 width=113) (actual time=0.045..0.351 rows=36 loops=1)

4. 0.019 0.197 ↑ 62.8 36 1

Hash Join (cost=34.51..17,875.98 rows=2,260 width=113) (actual time=0.038..0.197 rows=36 loops=1)

  • Hash Cond: (e.data_source_id = ds.id)
5. 0.014 0.168 ↑ 62.8 36 1

Nested Loop (cost=0.43..17,835.95 rows=2,260 width=81) (actual time=0.018..0.168 rows=36 loops=1)

6. 0.010 0.010 ↑ 62.8 36 1

Seq Scan on tmp_place_descriptions tmp (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.007..0.010 rows=36 loops=1)

7. 0.144 0.144 ↑ 1.0 1 36

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

  • Index Cond: (id = tmp.id)
8. 0.006 0.010 ↑ 76.4 14 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
9. 0.004 0.004 ↑ 76.4 14 1

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

10. 0.144 0.144 ↑ 1.0 1 36

Index Scan using place_description_current_version_pointer_ux1 on place_description_current_version_pointer cvp (cost=0.43..0.50 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=36)

  • Index Cond: (place_description_id = e.id)
11. 0.144 0.144 ↑ 1.0 1 36

Index Scan using place_description_version_pkey on place_description_version v (cost=0.43..0.71 rows=1 width=68) (actual time=0.004..0.004 rows=1 loops=36)

  • Index Cond: (id = cvp.place_description_version_id)
12. 0.108 0.108 ↑ 1.0 1 36

Index Scan using address_pkey on address a (cost=0.43..0.51 rows=1 width=59) (actual time=0.003..0.003 rows=1 loops=36)

  • Index Cond: (v.address_id = id)
Planning time : 1.990 ms
Execution time : 0.720 ms