explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UGMc : ttt

Settings
# exclusive inclusive rows x rows loops node
1. 9.183 20.240 ↑ 1.2 16,049 1

Result (cost=0.00..327.09 rows=18,709 width=31) (actual time=0.010..20.240 rows=16,049 loops=1)

2. 6.704 11.057 ↑ 1.2 16,049 1

Append (cost=0.00..327.09 rows=18,709 width=31) (actual time=0.007..11.057 rows=16,049 loops=1)

3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on payment (cost=0.00..23.30 rows=1,330 width=31) (actual time=0.001..0.001 rows=0 loops=1)

4. 0.340 0.340 ↑ 1.0 1,157 1

Seq Scan on payment_p2007_01 payment (cost=0.00..20.57 rows=1,157 width=28) (actual time=0.006..0.340 rows=1,157 loops=1)

5. 0.635 0.635 ↑ 1.0 2,312 1

Seq Scan on payment_p2007_02 payment (cost=0.00..40.12 rows=2,312 width=28) (actual time=0.003..0.635 rows=2,312 loops=1)

6. 1.521 1.521 ↑ 1.0 5,644 1

Seq Scan on payment_p2007_03 payment (cost=0.00..98.44 rows=5,644 width=28) (actual time=0.003..1.521 rows=5,644 loops=1)

7. 1.805 1.805 ↑ 1.0 6,754 1

Seq Scan on payment_p2007_04 payment (cost=0.00..117.54 rows=6,754 width=28) (actual time=0.003..1.805 rows=6,754 loops=1)

8. 0.051 0.051 ↑ 1.0 182 1

Seq Scan on payment_p2007_05 payment (cost=0.00..3.82 rows=182 width=27) (actual time=0.003..0.051 rows=182 loops=1)

9. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on payment_p2007_06 payment (cost=0.00..23.30 rows=1,330 width=31) (actual time=0.000..0.000 rows=0 loops=1)