explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oAPn

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 270.564 ↓ 0.0 0 1

Insert on two (cost=4,083.540..231,500.540 rows=13 width=44) (actual time=270.564..270.564 rows=0 loops=1)

2. 0.001 270.563 ↓ 0.0 0 1

Subquery Scan on yankee (cost=4,083.540..231,500.540 rows=13 width=44) (actual time=270.563..270.563 rows=0 loops=1)

3. 6.843 270.562 ↓ 0.0 0 1

Hash Semi Join (cost=4,083.540..231,500.350 rows=13 width=36) (actual time=270.562..270.562 rows=0 loops=1)

  • Hash Cond: ((romeo.juliet = xray1.juliet) AND ((delta 2) = xray1.echo_hotel))
  • Join Filter: ((romeo.papa <> xray1.echo_charlie) OR (xray1.echo_charlie five NULL))
  • Rows Removed by Join Filter: 13
4.          

CTE romeo

5. 0.047 0.047 ↑ 1.0 13 1

Values Scan on *VALUES* (cost=0.000..0.160 rows=13 width=36) (actual time=0.002..0.047 rows=13 loops=1)

6. 0.073 0.073 ↑ 1.0 13 1

CTE Scan on romeo (cost=0.000..0.260 rows=13 width=36) (actual time=0.003..0.073 rows=13 loops=1)

7. 19.588 28.346 ↑ 1.0 96,449 1

Hash (cost=1,934.150..1,934.150 rows=98,415 width=28) (actual time=28.346..28.346 rows=96,449 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3530kB
8. 8.758 8.758 ↑ 1.0 96,449 1

Seq Scan on two six (cost=0.000..1,934.150 rows=98,415 width=28) (actual time=0.008..8.758 rows=96,449 loops=1)

9.          

SubPlan (for Hash Semi Join)

10. 0.182 235.300 ↑ 1.0 1 26

Aggregate (cost=2,180.190..2,180.200 rows=1 width=8) (actual time=9.050..9.050 rows=1 loops=26)

11. 235.118 235.118 ↑ 1.0 1 26

Seq Scan on two november (cost=0.000..2,180.190 rows=1 width=8) (actual time=1.339..9.043 rows=1 loops=26)

  • Filter: (juliet = romeo.juliet)
  • Rows Removed by Filter: 96448
Planning time : 0.155 ms
Execution time : 270.626 ms