explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bQnh : g

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 0.237 ↓ 2.0 2 1

WindowAgg (cost=12.690..12.720 rows=1 width=136) (actual time=0.213..0.237 rows=2 loops=1)

2. 0.031 0.200 ↓ 2.0 2 1

Sort (cost=12.690..12.690 rows=1 width=181) (actual time=0.187..0.200 rows=2 loops=1)

  • Sort Key: ((lima.uniform_foxtrot ->> 'zulu'::text))
  • Sort Method: quicksort Memory: 25kB
3. 0.033 0.169 ↓ 2.0 2 1

GroupAggregate (cost=12.650..12.680 rows=1 width=181) (actual time=0.146..0.169 rows=2 loops=1)

  • Group Key: kilo.quebec_seven, ((lima.uniform_foxtrot ->> 'alpha_three'::text)), ((lima.uniform_foxtrot ->> 'zulu'::text))
4. 0.034 0.136 ↓ 2.0 2 1

Sort (cost=12.650..12.650 rows=1 width=173) (actual time=0.123..0.136 rows=2 loops=1)

  • Sort Key: ((lima.uniform_foxtrot ->> 'alpha_three'::text)), ((lima.uniform_foxtrot ->> 'zulu'::text))
  • Sort Method: quicksort Memory: 25kB
5. 0.034 0.102 ↓ 2.0 2 1

Nested Loop (cost=0.150..12.640 rows=1 width=173) (actual time=0.044..0.102 rows=2 loops=1)

6. 0.023 0.023 ↑ 1.0 1 1

Index Scan using mike on six kilo (cost=0.150..8.170 rows=1 width=32) (actual time=0.014..0.023 rows=1 loops=1)

  • Index Cond: (quebec_seven = 'yankee'::uuid)
7. 0.045 0.045 ↓ 2.0 2 1

Seq Scan on quebec_lima lima (cost=0.000..4.450 rows=1 width=93) (actual time=0.015..0.045 rows=2 loops=1)

  • Filter: (((november)::text = ANY ('victor'::text[])) AND (tango = 'yankee'::uuid) AND ((uniform_delta)::text = 'alpha_seven'::text))
  • Rows Removed by Filter: 82