explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wLIR

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 4,728.461 ↑ 1.0 132 1

Aggregate (cost=209,619.110..209,620.430 rows=132 width=8) (actual time=4,728.452..4,728.461 rows=132 loops=1)

2. 4,403.622 4,728.412 ↑ 454.8 152 1

Nested Loop (cost=0.000..209,446.300 rows=69,125 width=8) (actual time=0.024..4,728.412 rows=152 loops=1)

3. 10.330 10.330 ↓ 1.0 104,820 1

Seq Scan on four four (cost=0.000..2,068.350 rows=104,735 width=39) (actual time=0.006..10.330 rows=104,820 loops=1)

4. 314.454 314.460 ↑ 1.0 132 104,820

Materialize (cost=0.000..2.980 rows=132 width=17) (actual time=0.000..0.003 rows=132 loops=104,820)

5. 0.006 0.006 ↑ 1.0 132 1

Seq Scan on romeo romeo (cost=0.000..2.320 rows=132 width=17) (actual time=0.002..0.006 rows=132 loops=1)

Planning time : 0.095 ms
Execution time : 4,728.496 ms