explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vu8a

Settings
# exclusive inclusive rows x rows loops node
1. 1.324 374.236 ↓ 188.0 188 1

Nested Loop Left Join (cost=71.46..533.00 rows=1 width=383) (actual time=0.776..374.236 rows=188 loops=1)

2. 0.109 372.536 ↓ 188.0 188 1

Nested Loop Left Join (cost=71.31..532.53 rows=1 width=355) (actual time=0.758..372.536 rows=188 loops=1)

3. 0.176 372.051 ↓ 188.0 188 1

Nested Loop Left Join (cost=71.16..532.15 rows=1 width=351) (actual time=0.756..372.051 rows=188 loops=1)

4. 0.185 187.071 ↓ 188.0 188 1

Nested Loop Left Join (cost=70.46..312.54 rows=1 width=345) (actual time=0.572..187.071 rows=188 loops=1)

5. 0.159 2.458 ↓ 188.0 188 1

Nested Loop (cost=69.76..92.93 rows=1 width=339) (actual time=0.089..2.458 rows=188 loops=1)

6. 0.180 2.111 ↓ 188.0 188 1

Nested Loop (cost=69.61..92.72 rows=1 width=311) (actual time=0.087..2.111 rows=188 loops=1)

7. 0.168 1.743 ↓ 188.0 188 1

Nested Loop (cost=69.46..92.51 rows=1 width=283) (actual time=0.084..1.743 rows=188 loops=1)

8. 0.081 1.387 ↓ 188.0 188 1

Nested Loop (cost=69.31..92.30 rows=1 width=255) (actual time=0.081..1.387 rows=188 loops=1)

9. 0.211 0.930 ↓ 188.0 188 1

Nested Loop (cost=69.15..92.09 rows=1 width=263) (actual time=0.069..0.930 rows=188 loops=1)

10. 0.170 0.531 ↓ 188.0 188 1

Hash Join (cost=69.00..91.89 rows=1 width=255) (actual time=0.063..0.531 rows=188 loops=1)

  • Hash Cond: ((sierra_november.quebec_three_yankee = juliet.quebec_three_yankee) AND (lima.papa_romeo = juliet.quebec_seven))
11. 0.260 0.344 ↑ 1.0 188 1

Hash Join (cost=48.25..69.72 rows=188 width=191) (actual time=0.030..0.344 rows=188 loops=1)

  • Hash Cond: (lima.alpha_bravo_kilo = sierra_november.quebec_seven)
12. 0.071 0.071 ↑ 1.0 188 1

Seq Scan on four_echo_seven lima (cost=0.00..18.88 rows=188 width=187) (actual time=0.001..0.071 rows=188 loops=1)

13. 0.008 0.013 ↑ 89.5 19 1

Hash (cost=27.00..27.00 rows=1,700 width=12) (actual time=0.013..0.013 rows=19 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
14. 0.005 0.005 ↑ 89.5 19 1

Seq Scan on india sierra_november (cost=0.00..27.00 rows=1,700 width=12) (actual time=0.002..0.005 rows=19 loops=1)

15. 0.014 0.017 ↑ 430.0 1 1

Hash (cost=14.30..14.30 rows=430 width=72) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.003 0.003 ↑ 430.0 1 1

Seq Scan on tango_papa juliet (cost=0.00..14.30 rows=430 width=72) (actual time=0.003..0.003 rows=1 loops=1)

17. 0.188 0.188 ↑ 1.0 1 188

Index Scan using mike_tango on oscar_yankee papa_xray (cost=0.15..0.20 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (quebec_seven = sierra_november.four_echo_yankee)
18. 0.376 0.376 ↑ 1.0 1 188

Index Only Scan using yankee_charlie on bravo six_xray (cost=0.15..0.20 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=188)

  • Index Cond: (quebec_seven = sierra_november.quebec_three_yankee)
  • Heap Fetches: 188
19. 0.188 0.188 ↑ 1.0 1 188

Index Scan using whiskey on tango_quebec papa_india (cost=0.15..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (quebec_seven = papa_xray.six_romeo)
20. 0.188 0.188 ↑ 1.0 1 188

Index Scan using november_echo on kilo charlie (cost=0.15..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (quebec_seven = papa_xray.tango_xray)
21. 0.188 0.188 ↑ 1.0 1 188

Index Scan using six_four on victor zulu (cost=0.15..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (quebec_seven = papa_xray.seven)
22. 60.536 184.428 ↑ 1.0 1 188

Nested Loop (cost=0.70..219.60 rows=1 width=10) (actual time=0.648..0.981 rows=1 loops=188)

23. 18.612 18.612 ↓ 1.0 560 188

Index Scan using mike_two on sierra_juliet alpha_foxtrot (cost=0.42..40.49 rows=556 width=14) (actual time=0.010..0.099 rows=560 loops=188)

  • Index Cond: (oscar_six = lima.quebec_seven)
24. 105.280 105.280 ↓ 0.0 0 105,280

Index Scan using yankee_papa on three hotel (cost=0.28..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=105,280)

  • Index Cond: (quebec_seven = november_two1.echo)
  • Filter: ((golf)::text = 'xray'::text)
  • Rows Removed by Filter: 1
25. 61.664 184.804 ↑ 1.0 1 188

Nested Loop (cost=0.70..219.60 rows=1 width=10) (actual time=0.311..0.983 rows=1 loops=188)

26. 17.860 17.860 ↓ 1.0 560 188

Index Scan using mike_two on sierra_juliet papa_kilo (cost=0.42..40.49 rows=556 width=14) (actual time=0.008..0.095 rows=560 loops=188)

  • Index Cond: (oscar_six = lima.quebec_seven)
27. 105.280 105.280 ↓ 0.0 0 105,280

Index Scan using yankee_papa on three yankee_tango (cost=0.28..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=105,280)

  • Index Cond: (quebec_seven = papa_kilo.echo)
  • Filter: ((golf)::text = 'alpha_bravo_zulu'::text)
  • Rows Removed by Filter: 1
28. 0.376 0.376 ↑ 1.0 1 188

Index Scan using oscar_delta on two quebec_three_three (cost=0.14..0.38 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=188)

  • Index Cond: (lima.quebec_seven = oscar_six)
29. 0.376 0.376 ↑ 1.0 1 188

Index Scan using alpha_sierra on romeo_papa romeo_three (cost=0.15..0.43 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=188)

  • Index Cond: (quebec_three_three.delta = quebec_seven)