explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NChI

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 2.850 ↑ 111.0 1 1

Unique (cost=259.680..260.230 rows=111 width=47) (actual time=2.807..2.850 rows=1 loops=1)

2. 0.070 2.816 ↑ 1.0 110 1

Sort (cost=259.680..259.960 rows=111 width=47) (actual time=2.805..2.816 rows=110 loops=1)

  • Sort Key: charlie.oscar
  • Sort Method: quicksort Memory: 40kB
3. 0.040 2.746 ↑ 1.0 110 1

Subquery Scan on charlie (cost=254.520..255.910 rows=111 width=47) (actual time=2.697..2.746 rows=110 loops=1)

4. 0.085 2.706 ↑ 1.0 110 1

Sort (cost=254.520..254.800 rows=111 width=277) (actual time=2.695..2.706 rows=110 loops=1)

  • Sort Key: yankee8kilo109five_juliet.xray DESC
  • Sort Method: quicksort Memory: 40kB
5. 0.032 2.621 ↑ 1.0 110 1

Result (cost=0.000..250.750 rows=111 width=277) (actual time=2.380..2.621 rows=110 loops=1)

6. 0.018 2.589 ↑ 1.0 110 1

Append (cost=0.000..249.640 rows=111 width=45) (actual time=2.377..2.589 rows=110 loops=1)

7. 2.365 2.365 ↓ 0.0 0 1

Seq Scan on five_kilo (cost=0.000..230.370 rows=1 width=43) (actual time=2.365..2.365 rows=0 loops=1)

  • Filter: (((oscar)::text <> ''::text) AND (romeo < 100))
  • Rows Removed by Filter: 7558
8. 0.206 0.206 ↑ 1.0 110 1

Seq Scan on india (cost=0.000..18.710 rows=110 width=45) (actual time=0.010..0.206 rows=110 loops=1)

  • Filter: (((oscar)::text <> ''::text) AND (romeo < 100))
  • Rows Removed by Filter: 471
Planning time : 0.574 ms
Execution time : 2.915 ms