explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sDgJ

Settings
# exclusive inclusive rows x rows loops node
1. 4.372 5,746.792 ↓ 1.3 33,772 1

Result (cost=0.00..546,113.20 rows=26,522 width=2,492) (actual time=467.350..5,746.792 rows=33,772 loops=1)

2. 2.917 5,742.420 ↓ 1.3 33,772 1

Append (cost=0.00..545,847.98 rows=26,522 width=1,976) (actual time=467.349..5,742.420 rows=33,772 loops=1)

3. 5,344.422 5,344.422 ↓ 1.3 33,772 1

Seq Scan on "ConnectorSmev_reports" (cost=0.00..506,153.74 rows=26,521 width=1,976) (actual time=467.348..5,344.422 rows=33,772 loops=1)

  • Filter: (("requestTimestamp" >= '2019-07-01 00:00:00'::timestamp without time zone) AND ("requestTimestamp" <= '2019-07-02 00:00:00'::timestamp without time zone) AND (("serviceCode
  • Rows Removed by Filter: 9530858
4. 395.081 395.081 ↓ 0.0 0 1

Seq Scan on "ConnectorSmev_reports_history" "ConnectorSmev_reports_1" (cost=0.00..39,694.24 rows=1 width=1,905) (actual time=395.081..395.081 rows=0 loops=1)

  • Filter: (("requestTimestamp" >= '2019-07-01 00:00:00'::timestamp without time zone) AND ("requestTimestamp" <= '2019-07-02 00:00:00'::timestamp without time zone) AND (("serviceCode
  • Rows Removed by Filter: 736594
Planning time : 2.148 ms
Execution time : 5,748.434 ms