explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xtxn

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 20,045.588 ↑ 1.0 1 1

Limit (cost=26.740..26.740 rows=1 width=39) (actual time=20,045.579..20,045.588 rows=1 loops=1)

  • loops=1)
2. 0.012 20,045.578 ↑ 1.0 1 1

Sort (cost=26.740..26.740 rows=1 width=39) (actual time=20,045.577..20,045.578 rows=1 loops=1)

  • Sort Key: hotel.two DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.004 20,045.566 ↑ 1.0 1 1

Nested Loop (cost=1.260..26.730 rows=1 width=39) (actual time=20.790..20,045.566 rows=1 loops=1)

  • Join Filter: (((papa.five_kilo)::text = 'november_three'::text) OR hotel.xray)
4. 0.006 20,045.553 ↑ 1.0 1 1

Nested Loop (cost=1.260..25.350 rows=1 width=33) (actual time=20.777..20,045.553 rows=1 loops=1)

5. 18.080 18.080 ↑ 1.0 1 1

Index Scan using sierra on kilo (cost=0.410..8.430 rows=1 width=4) (actual time=18.077..18.080 rows=1 loops=1)

  • Index Cond: ((november_lima)::text = 'echo'::text)
6. 20,026.316 20,027.467 ↑ 1.0 1 1

Nested Loop (cost=0.850..16.910 rows=1 width=37) (actual time=2.694..20,027.467 rows=1 loops=1)

  • -> Index Scan using builds_products_branches_idx on builds (cost=0.56..8.60 rows=1 width=23) (actual time=1.539..20026.308 rows=1
7. 1.151 1.151 ↑ 1.0 1 1

Index Scan using five_five on seven (cost=0.290..8.300 rows=1 width=22) (actual time=1.149..1.151 rows=1 loops=1)

  • Index Cond: ((november_lima)::text = 'lima_november'::text)
  • Index Cond: ((oscar_quebec = seven.oscar_quebec) AND (alpha_charlie = kilo.alpha_charlie))
  • Filter: ((charlie five_romeo NULL) AND ((five_two)::text = 'lima_bravo'::text) AND ((oscar_charlie)::text = 'bravo'::text) AND ((juliet)::text = 'tango_alpha'::text) AND ((yankee)::text = ANY ('tango_victor'::text[])))
  • Rows Removed by Filter: 47990
8. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on papa (cost=0.000..1.360 rows=1 width=19) (actual time=0.008..0.009 rows=1 loops=1)

  • Filter: ((alpha_juliet)::text = 'tango_alpha'::text)
  • Rows Removed by Filter: 4
Planning time : 0.795 ms
Execution time : 20,045.649 ms