explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dq7c

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.081 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.88..66.85 rows=3 width=224) (actual time=0.042..0.081 rows=3 loops=1)

2. 0.004 0.063 ↑ 1.0 3 1

Nested Loop (cost=1.45..65.33 rows=3 width=165) (actual time=0.033..0.063 rows=3 loops=1)

3. 0.002 0.053 ↑ 1.0 3 1

Nested Loop (cost=1.29..44.80 rows=3 width=133) (actual time=0.027..0.053 rows=3 loops=1)

4. 0.005 0.036 ↑ 1.0 3 1

Nested Loop (cost=0.86..42.69 rows=3 width=81) (actual time=0.018..0.036 rows=3 loops=1)

5. 0.019 0.019 ↑ 1.0 3 1

Index Scan using place_description_pkey on place_description e (cost=0.43..17.34 rows=3 width=73) (actual time=0.010..0.019 rows=3 loops=1)

  • Index Cond: (id = ANY ('{3048388,3048041,3047960}'::bigint[]))
6. 0.012 0.012 ↑ 1.0 1 3

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

  • Index Cond: (place_description_id = e.id)
7. 0.015 0.015 ↑ 1.0 1 3

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

  • Index Cond: (id = cvp.place_description_version_id)
8. 0.006 0.006 ↑ 1.0 1 3

Index Scan using data_source_pkey on data_source ds (cost=0.15..6.84 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = e.data_source_id)
9. 0.015 0.015 ↑ 1.0 1 3

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

  • Index Cond: (v.address_id = id)
Planning time : 1.028 ms
Execution time : 0.141 ms