explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BUxK

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.426 ↑ 1.0 51 1

Limit (cost=96,193.000..96,193.200 rows=51 width=90) (actual time=0.400..0.426 rows=51 loops=1)

2.          

CTE six

3. 0.011 0.412 ↑ 10.0 51 1

WindowAgg (cost=96,189.940..96,193.000 rows=510 width=45) (actual time=0.398..0.412 rows=51 loops=1)

4. 0.001 0.401 ↑ 10.0 51 1

Limit (cost=96,189.940..96,190.190 rows=510 width=45) (actual time=0.396..0.401 rows=51 loops=1)

5. 0.046 0.400 ↑ 28.9 51 1

Sort (cost=96,189.940..96,190.670 rows=1,472 width=45) (actual time=0.396..0.400 rows=51 loops=1)

  • Sort Key: alpha_quebec.india DESC, alpha_quebec.two DESC
  • Sort Method: quicksort Memory: 41kB
6. 0.025 0.354 ↑ 7.0 209 1

Nested Loop (cost=0.210..96,175.230 rows=1,472 width=45) (actual time=0.030..0.354 rows=209 loops=1)

7. 0.002 0.033 ↓ 2.0 4 1

Nested Loop (cost=0.070..20.270 rows=2 width=8) (actual time=0.010..0.033 rows=4 loops=1)

8. 0.002 0.003 ↑ 1.0 4 1

HashAggregate (cost=0.010..0.020 rows=4 width=4) (actual time=0.003..0.003 rows=4 loops=1)

  • Group Key: "quebec_kilo".victor1
9. 0.001 0.001 ↑ 1.0 4 1

Values Scan on "*VALUES*" (cost=0.000..0.010 rows=4 width=4) (actual time=0.001..0.001 rows=4 loops=1)

10. 0.028 0.028 ↑ 1.0 1 4

Index Scan using mike_victor on hotel_charlie hotel_quebec (cost=0.060..5.060 rows=1 width=4) (actual time=0.004..0.007 rows=1 loops=4)

  • Index Cond: (seven = "quebec_kilo".victor1)
  • Filter: (mike_three = 1)
11. 0.296 0.296 ↑ 12.9 52 4

Index Only Scan using quebec_tango on papa alpha_quebec (cost=0.140..48,076.130 rows=673 width=49) (actual time=0.010..0.074 rows=52 loops=4)

  • Index Cond: ((kilo = 'romeo_seven'::text) AND (seven = hotel_quebec.seven) AND (india >= (('juliet'::cstring)::timestamp without time zone - 'romeo_foxtrot'::interval uniform)) AND (india <= ('juliet'::cstring)::timestamp without time zone))
  • Filter: (CASE WHEN ((tango_zulu five NULL) AND (mike_yankee five NULL)) THEN 1 WHEN (delta 1) THEN 1 ELSE NULL::integer END five NOT NULL)
  • Heap Fetches: 183
12.          

SubPlan (for Index Only Scan)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_november on tango_echo (cost=0.110..138.430 rows=1 width=11) (never executed)

  • Index Cond: (((alpha_yankee)::text = ANY ('four'::text[])) AND ((tango_zulu)::text = (alpha_quebec.tango_zulu)::text) AND (mike_yankee = alpha_quebec.mike_yankee))
  • Filter: (((NOT three) OR (three five NULL)) AND ((tango_papa = ANY ('lima'::boolean[])) OR (tango_papa five NULL)))
14. 0.424 0.424 ↑ 10.0 51 1

CTE Scan on six (cost=0.000..2.040 rows=510 width=90) (actual time=0.400..0.424 rows=51 loops=1)