explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LhVC

Settings
# exclusive inclusive rows x rows loops node
1. 5.474 2,098.673 ↓ 0.0 0 1

Limit (cost=340,196.500..340,196.510 rows=1 width=377) (actual time=2,098.673..2,098.673 rows=0 loops=1)

  • Functions: 13
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 2.146 ms, Inlining 0.000 ms, Optimization 1.520 ms, Emission 19.770 ms, Total 23.436 ms
2. 0.000 2,093.199 ↓ 0.0 0 1

Sort (cost=340,196.500..340,196.510 rows=1 width=377) (actual time=2,093.199..2,093.199 rows=0 loops=1)

  • Sort Key: november_lima
  • Sort Method: quicksort Memory: 25kB
3. 19.243 2,097.587 ↓ 0.0 0 1

Gather (cost=1,000.000..340,196.490 rows=1 width=377) (actual time=2,093.191..2,097.587 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,078.344 2,078.344 ↓ 0.0 0 3 / 3

Parallel Seq Scan on zulu foxtrot_charlie (cost=0.000..339,196.390 rows=1 width=377) (actual time=2,078.344..2,078.344 rows=0 loops=3)

  • Filter: (foxtrot_oscar AND (charlie ~~ 'yankee'::text) AND (november_victor = ANY ('india'::text[])) AND (whiskey = 'seven'::text))
  • Rows Removed by Filter: 1,385,111
Planning time : 0.144 ms
Execution time : 2,103.845 ms