explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cFZkq : ttt

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 5.193 ↑ 1.5 37 1

Result (cost=0.00..420.63 rows=54 width=31) (actual time=0.262..5.193 rows=37 loops=1)

  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
  • AND (payment_date <= '2007-02-15 00:00:00'::timestamp without time zone))
2. 0.134 5.173 ↑ 1.5 37 1

Append (cost=0.00..420.63 rows=54 width=31) (actual time=0.261..5.173 rows=37 loops=1)

3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on payment (cost=0.00..29.95 rows=7 width=31) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)
4. 0.244 0.244 ↓ 0.0 0 1

Seq Scan on payment_p2007_01 payment (cost=0.00..26.36 rows=1 width=28) (actual time=0.244..0.244 rows=0 loops=1)

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)
5. 0.598 0.598 ↓ 1.0 37 1

Seq Scan on payment_p2007_02 payment (cost=0.00..51.68 rows=36 width=28) (actual time=0.014..0.598 rows=37 loops=1)

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)
6. 1.461 1.461 ↓ 0.0 0 1

Seq Scan on payment_p2007_03 payment (cost=0.00..126.66 rows=1 width=28) (actual time=1.461..1.461 rows=0 loops=1)

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)
7. 2.683 2.683 ↓ 0.0 0 1

Seq Scan on payment_p2007_04 payment (cost=0.00..151.31 rows=1 width=28) (actual time=2.683..2.683 rows=0 loops=1)

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)
8. 0.052 0.052 ↓ 0.0 0 1

Seq Scan on payment_p2007_05 payment (cost=0.00..4.73 rows=1 width=27) (actual time=0.052..0.052 rows=0 loops=1)

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)
9. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: ((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone)