explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VfMn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 27,243.279 ↓ 128,749.6 2,446,242 1

Nested Loop (cost=10,732.98..1,891,095.58 rows=19 width=4) (actual time=2,062.661..27,243.279 rows=2,446,242 loops=1)

2. 688.890 5,298.128 ↓ 117,828.9 3,181,380 1

Hash Join (cost=10,732.55..1,891,055.28 rows=27 width=4) (actual time=2,061.623..5,298.128 rows=3,181,380 loops=1)

  • Hash Cond: (b1.imsgid = b2.ibroadlogmsgid)
3. 4,570.724 4,570.724 ↓ 70.1 3,185,384 1

Index Scan using nmsbroadlogrcp_delivery on nmsbroadlogrcp b1 (cost=0.57..1,880,152.69 rows=45,426 width=8) (actual time=2,022.634..4,570.724 rows=3,185,384 loops=1)

  • Index Cond: (ideliveryid = 29,136,107)
  • Filter: ((tsevent >= '2020-09-14 11:00:00+00'::timestamp with time zone) AND (tsevent <= '2020-09-16 11:00:00+00'::timestamp with time zone) AND (iprofileid <> 0))
4. 0.046 38.514 ↑ 6.5 22 1

Hash (cost=10,730.20..10,730.20 rows=142 width=4) (actual time=38.513..38.514 rows=22 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 38.468 38.468 ↑ 6.5 22 1

Seq Scan on nmsbroadlogmsg b2 (cost=0.00..10,730.20 rows=142 width=4) (actual time=0.015..38.468 rows=22 loops=1)

  • Filter: (ifailurereason = 0)
  • Rows Removed by Filter: 241,871
6. 22,269.660 22,269.660 ↑ 1.0 1 3,181,380

Index Scan using ndxr_29533183t on wkdlv_29533183t w0 (cost=0.43..1.48 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=3,181,380)

  • Index Cond: (iprofileid = b1.iprofileid)
  • Filter: (ideliveryid = 29,533,183)
Planning time : 24.094 ms
Execution time : 27,305.856 ms