explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1bOA : Patron_data_purge

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 18,264.994 ↓ 0.0 0 1

Limit (cost=18.35..1,271.98 rows=500 width=32) (actual time=18,264.994..18,264.994 rows=0 loops=1)

2. 694.957 18,264.993 ↓ 0.0 0 1

Nested Loop Anti Join (cost=18.35..836,300.67 rows=333,545 width=32) (actual time=18,264.993..18,264.993 rows=0 loops=1)

3. 10,682.545 12,296.032 ↓ 2.7 1,318,501 1

Hash Left Join (cost=17.92..329,677.45 rows=495,787 width=24) (actual time=0.585..12,296.032 rows=1,318,501 loops=1)

  • Hash Cond: ((r.requestersymbol)::text = (p.institutionsymbol)::text)
  • Filter: (date_diff_in_months((r.closeddate)::timestamp with time zone, '2018-11-05 18:23:14.654-05'::timestamp with time zone) > (CO
  • Rows Removed by Filter: 1655749
4. 1,613.096 1,613.096 ↓ 2.0 2,974,250 1

Seq Scan on request r (cost=1.18..270,222.24 rows=1,487,362 width=20) (actual time=0.070..1,613.096 rows=2,974,250 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 14
  • -> Seq Scan on patronpurgeblacklistedrequest pbr (cost=0.00..1.14 rows=14 width=8) (actual time=0.024..0.027 rows=14 loops
5. 0.187 0.391 ↓ 1.0 532 1

Hash (cost=10.22..10.22 rows=522 width=8) (actual time=0.391..0.391 rows=532 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
6. 0.204 0.204 ↓ 1.0 532 1

Seq Scan on patronsettings p (cost=0.00..10.22 rows=522 width=8) (actual time=0.014..0.204 rows=532 loops=1)

7. 5,274.004 5,274.004 ↑ 1.0 1 1,318,501

Index Scan using event_requestid_idx on event e (cost=0.43..0.87 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1,318,501)

  • Index Cond: (requestid = r.requestid)
  • Filter: ((eventtype)::text = 'PATRON_DATA_PURGE'::text)
  • Rows Removed by Filter: 0