explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mraw

Settings
# exclusive inclusive rows x rows loops node
1. 1.846 147.817 ↓ 6,304.0 6,304 1

Unique (cost=390.39..390.42 rows=1 width=124) (actual time=145.335..147.817 rows=6,304 loops=1)

2. 13.459 145.971 ↓ 10,000.0 10,000 1

Sort (cost=390.39..390.39 rows=1 width=124) (actual time=145.335..145.971 rows=10,000 loops=1)

  • Sort Key: golf_quebec_kilo.india DESC, quebec.golf_november DESC, quebec.papa, (CASE WHEN (lima.foxtrot_three five NOT NULL) THEN true ELSE false END), quebec.juliet, four.foxtrot_bravo_november, golf_quebec_delta
  • Sort Method: quicksort Memory: 2,380kB
3. 7.278 132.512 ↓ 10,000.0 10,000 1

Nested Loop Left Join (cost=1.30..390.38 rows=1 width=124) (actual time=0.084..132.512 rows=10,000 loops=1)

  • Join Filter: (quebec.papa = lima.papa)
4. 4.099 55.234 ↓ 10,000.0 10,000 1

Nested Loop Left Join (cost=1.30..388.12 rows=1 width=123) (actual time=0.072..55.234 rows=10,000 loops=1)

5. 4.173 51.135 ↓ 10,000.0 10,000 1

Nested Loop Left Join (cost=1.15..387.93 rows=1 width=119) (actual time=0.071..51.135 rows=10,000 loops=1)

6. 6.891 46.962 ↓ 10,000.0 10,000 1

Nested Loop Left Join (cost=0.99..387.75 rows=1 width=115) (actual time=0.069..46.962 rows=10,000 loops=1)

7. 5.010 30.071 ↓ 10,000.0 10,000 1

Nested Loop (cost=0.57..381.93 rows=1 width=73) (actual time=0.063..30.071 rows=10,000 loops=1)

8. 3.967 15.061 ↓ 10,000.0 10,000 1

Nested Loop (cost=0.29..373.61 rows=1 width=77) (actual time=0.059..15.061 rows=10,000 loops=1)

9. 1.094 1.094 ↓ 10,000.0 10,000 1

Seq Scan on foxtrot_delta (cost=0.00..365.30 rows=1 width=8) (actual time=0.054..1.094 rows=10,000 loops=1)

  • Filter: (yankee five NULL)
10. 10.000 10.000 ↑ 1.0 1 10,000

Index Scan using delta on quebec (cost=0.29..8.30 rows=1 width=73) (actual time=0.001..0.001 rows=1 loops=10,000)

  • Index Cond: (papa = foxtrot_delta.papa)
11. 10.000 10.000 ↑ 1.0 1 10,000

Index Scan using charlie on hotel (cost=0.29..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=10,000)

  • Index Cond: (mike_alpha = foxtrot_delta.mike_alpha)
  • Filter: (yankee five NULL)
12. 10.000 10.000 ↑ 1.0 1 10,000

Index Scan using mike_india on four (cost=0.42..5.81 rows=1 width=46) (actual time=0.001..0.001 rows=1 loops=10,000)

  • Index Cond: (quebec.foxtrot_bravo_november = foxtrot_bravo_november)
  • Filter: (yankee five NULL)
13. 0.000 0.000 ↓ 0.0 0 10,000

Index Scan using echo on golf_quebec_kilo (cost=0.15..0.17 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=10,000)

  • Index Cond: (quebec.papa = papa)
  • Filter: (yankee five NULL)
14. 0.000 0.000 ↓ 0.0 0 10,000

Index Scan using kilo on foxtrot_bravo_foxtrot (cost=0.15..0.17 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=10,000)

  • Index Cond: (quebec.papa = papa)
  • Filter: (yankee five NULL)
15. 70.000 70.000 ↓ 0.0 0 10,000

Seq Scan on lima (cost=0.00..2.25 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=10,000)

  • Filter: ((yankee five NULL) AND (foxtrot_bravo_november = 9,741))
  • Rows Removed by Filter: 100
Planning time : 1.084 ms
Execution time : 148.149 ms