explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zl5p

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 8.943 ↑ 1.0 25 1

Limit (cost=1.40..476.45 rows=25 width=223) (actual time=7.888..8.943 rows=25 loops=1)

2. 7.976 8.936 ↑ 2,701.2 25 1

Nested Loop Left Join (cost=1.40..1,283,173.20 rows=67,529 width=223) (actual time=7.887..8.936 rows=25 loops=1)

  • Join Filter: (t."TicketFunctionID" = t0."ID")
3. 0.031 0.935 ↑ 2,701.2 25 1

Nested Loop Left Join (cost=1.40..1,225,209.70 rows=67,529 width=180) (actual time=0.115..0.935 rows=25 loops=1)

4. 0.027 0.504 ↑ 2,701.2 25 1

Nested Loop Left Join (cost=0.98..1,155,141.81 rows=67,529 width=180) (actual time=0.070..0.504 rows=25 loops=1)

5. 0.034 0.402 ↑ 2,701.2 25 1

Nested Loop Left Join (cost=0.70..1,135,167.43 rows=67,529 width=132) (actual time=0.057..0.402 rows=25 loops=1)

6. 0.268 0.268 ↑ 2,701.2 25 1

Index Scan Backward using "IX_Messages_CreatedDate" on "Messages" m (cost=0.43..1,115,890.86 rows=67,529 width=104) (actual time=0.031..0.268 rows=25 loops=1)

  • Filter: (("DeliveryDate" >= '2020-07-21 00:00:00-04'::timestamp with time zone) AND ("DeliveryDate" < '2020-07-27 00:00:00-04'::timestamp with time zone) AND ("Status" = 1))
  • Rows Removed by Filter: 1
7. 0.100 0.100 ↓ 0.0 0 25

Index Scan using "IX_MessageQueue_MessageID" on "MessageQueue" m0 (cost=0.27..0.29 rows=1 width=44) (actual time=0.004..0.004 rows=0 loops=25)

  • Index Cond: ("MessageID" = m."ID")
8. 0.075 0.075 ↓ 0.0 0 25

Index Scan using "PK_Destinations" on "Destinations" d (cost=0.28..0.30 rows=1 width=64) (actual time=0.003..0.003 rows=0 loops=25)

  • Index Cond: ("ID" = m."SendToDestinationID")
9. 0.400 0.400 ↑ 1.0 1 25

Index Scan using "PK_Tickets" on "Tickets" t (cost=0.42..1.04 rows=1 width=32) (actual time=0.016..0.016 rows=1 loops=25)

  • Index Cond: ("ID" = m."TicketID")
10. 0.020 0.025 ↑ 8.0 1 25

Materialize (cost=0.00..1.12 rows=8 width=26) (actual time=0.001..0.001 rows=1 loops=25)

11. 0.005 0.005 ↑ 8.0 1 1

Seq Scan on "TicketFunctions" t0 (cost=0.00..1.08 rows=8 width=26) (actual time=0.005..0.005 rows=1 loops=1)

Planning time : 4.073 ms
Execution time : 10.032 ms