explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z1tV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 18.356 ↓ 0.0 0 1

Limit (cost=1,991.300..1,991.310 rows=1 width=377) (actual time=18.356..18.356 rows=0 loops=1)

2. 0.006 18.356 ↓ 0.0 0 1

Sort (cost=1,991.300..1,991.310 rows=1 width=377) (actual time=18.355..18.356 rows=0 loops=1)

  • Sort Key: november_lima
  • Sort Method: quicksort Memory: 25kB
3. 0.004 18.350 ↓ 0.0 0 1

Bitmap Heap Scan on zulu foxtrot_charlie (cost=223.400..1,991.290 rows=1 width=377) (actual time=18.349..18.350 rows=0 loops=1)

  • Recheck Cond: (charlie ~~ 'yankee'::text)
  • Filter: (foxtrot_oscar AND (november_victor = ANY ('india'::text[])) AND (whiskey = 'seven'::text))
4. 18.346 18.346 ↓ 0.0 0 1

Bitmap Index Scan on quebec (cost=0.000..223.400 rows=453 width=0) (actual time=18.346..18.346 rows=0 loops=1)

  • Index Cond: (charlie ~~ 'yankee'::text)
Planning time : 0.253 ms
Execution time : 18.407 ms