explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ymL0 : delivery_analytics

Settings
# exclusive inclusive rows x rows loops node
1. 0.323 7.109 ↑ 1.0 1,000 1

Limit (cost=0.06..45.26 rows=1,000 width=368) (actual time=0.086..7.109 rows=1,000 loops=1)

  • Buffers: shared hit=13
2. 1.783 6.786 ↑ 768,840,000,000,000,000.0 1,000 1

Nested Loop (cost=0.06..34,753,121,212,121,292,800.00 rows=768,840,000,000,000,000,000 width=368) (actual time=0.084..6.786 rows=1,000 loops=1)

  • Buffers: shared hit=13
3. 0.377 3.431 ↑ 14,672,519,083,969,466.0 524 1

Nested Loop (cost=0.05..155,321,212,121,290,240.00 rows=7,688,400,000,000,000,000 width=336) (actual time=0.075..3.431 rows=524 loops=1)

  • Buffers: shared hit=13
4. 0.186 2.196 ↑ 268,825,174,825,174.8 286 1

Nested Loop (cost=0.04..1,553,212,121,290,232.50 rows=76,884,000,000,000,000 width=304) (actual time=0.071..2.196 rows=286 loops=1)

  • Buffers: shared hit=13
5. 0.096 1.509 ↑ 4,603,832,335,329.3 167 1

Nested Loop (cost=0.04..15,532,121,290,232.38 rows=768,840,000,000,000 width=272) (actual time=0.067..1.509 rows=167 loops=1)

  • Buffers: shared hit=13
6. 0.060 1.089 ↑ 71,188,888,888.9 108 1

Nested Loop (cost=0.03..155,321,290,232.38 rows=7,688,400,000,000 width=240) (actual time=0.063..1.089 rows=108 loops=1)

  • Buffers: shared hit=13
7. 0.048 0.795 ↑ 985,692,307.7 78 1

Nested Loop (cost=0.02..1,553,290,232.37 rows=76,884,000,000 width=208) (actual time=0.059..0.795 rows=78 loops=1)

  • Buffers: shared hit=13
8. 0.032 0.558 ↑ 12,203,809.5 63 1

Nested Loop (cost=0.01..15,610,232.36 rows=768,840,000 width=176) (actual time=0.055..0.558 rows=63 loops=1)

  • Buffers: shared hit=13
9. 0.045 0.358 ↑ 137,292.9 56 1

Nested Loop (cost=0.01..233,432.36 rows=7,688,400 width=144) (actual time=0.051..0.358 rows=56 loops=1)

  • Buffers: shared hit=13
10. 0.018 0.105 ↑ 1,478.5 52 1

Append (cost=0.00..79,664.35 rows=76,884 width=80) (actual time=0.038..0.105 rows=52 loops=1)

  • Buffers: shared hit=13
11. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=80) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
12. 0.074 0.074 ↑ 931.3 52 1

Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 d_1 (cost=0.43..49,937.69 rows=48,428 width=80) (actual time=0.024..0.074 rows=52 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=13
13. 0.000 0.000 ↓ 0.0 0

Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2 (cost=0.43..29,342.23 rows=28,455 width=80) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
14. 0.208 0.208 ↑ 100.0 1 52

Function Scan on jsonb_each esme_delivered (cost=0.01..1.01 rows=100 width=64) (actual time=0.004..0.004 rows=1 loops=52)

15. 0.168 0.168 ↑ 100.0 1 56

Function Scan on jsonb_each esme_total (cost=0.01..1.01 rows=100 width=32) (actual time=0.002..0.003 rows=1 loops=56)

16. 0.189 0.189 ↑ 100.0 1 63

Function Scan on jsonb_each esme_undelivered (cost=0.01..1.01 rows=100 width=32) (actual time=0.002..0.003 rows=1 loops=63)

17. 0.234 0.234 ↑ 100.0 1 78

Function Scan on jsonb_each esme_pending (cost=0.01..1.01 rows=100 width=32) (actual time=0.002..0.003 rows=1 loops=78)

18. 0.324 0.324 ↑ 50.0 2 108

Function Scan on jsonb_each esme_failed (cost=0.01..1.01 rows=100 width=32) (actual time=0.002..0.003 rows=2 loops=108)

19. 0.501 0.501 ↑ 50.0 2 167

Function Scan on jsonb_each esme_percent_pend_w (cost=0.01..1.01 rows=100 width=32) (actual time=0.003..0.003 rows=2 loops=167)

20. 0.858 0.858 ↑ 50.0 2 286

Function Scan on jsonb_each esme_percent_pend (cost=0.01..1.01 rows=100 width=32) (actual time=0.003..0.003 rows=2 loops=286)

21. 1.572 1.572 ↑ 50.0 2 524

Function Scan on jsonb_each esme_pending_weighted (cost=0.01..1.01 rows=100 width=32) (actual time=0.003..0.003 rows=2 loops=524)