explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ttP0

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 3.879 ↑ 1.0 100 1

Limit (cost=4.24..5,053.07 rows=100 width=1,956) (actual time=0.088..3.879 rows=100 loops=1)

  • Buffers: shared hit=3011
2. 0.125 3.866 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=4.24..6,558,132.18 rows=129,894 width=1,956) (actual time=0.087..3.866 rows=100 loops=1)

  • Join Filter: (promised_delivery_time.id = orders.promised_delivery_time_id)
  • Rows Removed by Join Filter: 992
  • Buffers: shared hit=3011
3. 0.117 3.641 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=4.24..6,536,698.53 rows=129,894 width=1,883) (actual time=0.082..3.641 rows=100 loops=1)

  • Join Filter: (delivery_time.id = orders.delivery_time_id)
  • Rows Removed by Join Filter: 1015
  • Buffers: shared hit=3010
4. 0.072 3.424 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=4.24..6,515,264.88 rows=129,894 width=1,810) (actual time=0.068..3.424 rows=100 loops=1)

  • Buffers: shared hit=3009
5. 0.050 2.852 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=3.68..5,522,375.42 rows=129,894 width=1,637) (actual time=0.060..2.852 rows=100 loops=1)

  • Buffers: shared hit=2507
6. 0.034 2.302 ↑ 1,298.9 100 1

Nested Loop (cost=3.11..4,519,725.23 rows=129,894 width=1,579) (actual time=0.052..2.302 rows=100 loops=1)

  • Buffers: shared hit=2006
7. 0.078 1.768 ↑ 1,298.9 100 1

Nested Loop (cost=2.55..3,511,739.03 rows=129,894 width=1,507) (actual time=0.045..1.768 rows=100 loops=1)

  • Buffers: shared hit=1506
8. 0.018 1.690 ↑ 1,298.9 100 1

Nested Loop (cost=2.13..3,510,106.92 rows=129,894 width=1,422) (actual time=0.037..1.690 rows=100 loops=1)

  • Buffers: shared hit=1502
9. 0.041 1.172 ↑ 1,298.9 100 1

Nested Loop (cost=1.56..2,507,180.73 rows=129,894 width=1,373) (actual time=0.029..1.172 rows=100 loops=1)

  • Buffers: shared hit=1001
10. 0.087 0.631 ↑ 1,298.9 100 1

Nested Loop (cost=1.00..1,462,510.53 rows=129,894 width=484) (actual time=0.022..0.631 rows=100 loops=1)

  • Buffers: shared hit=501
11. 0.144 0.144 ↑ 1,298.9 100 1

Index Scan Backward using orders_vendor_uuid_id_idx on orders (cost=0.56..511,794.56 rows=129,894 width=386) (actual time=0.013..0.144 rows=100 loops=1)

  • Index Cond: (vendor_uuid = '7000c8b5-1327-4d8e-b0cf-b47e09945abd'::uuid)
  • Buffers: shared hit=100
12. 0.400 0.400 ↑ 1.0 1 100

Index Scan using users_pkey on users (cost=0.43..7.31 rows=1 width=98) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (uuid = orders.user_uuid)
  • Buffers: shared hit=401
13. 0.500 0.500 ↑ 1.0 1 100

Index Scan using client_pkey on client (cost=0.56..8.03 rows=1 width=889) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (uuid = orders.client_uuid)
  • Buffers: shared hit=500
14. 0.500 0.500 ↑ 1.0 1 100

Index Scan using commission_pkey on commission (cost=0.56..7.71 rows=1 width=49) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (uuid = orders.commission_uuid)
  • Buffers: shared hit=501
15. 0.000 0.000 ↑ 1.0 1 100

Materialize (cost=0.42..8.44 rows=1 width=85) (actual time=0.000..0.000 rows=1 loops=100)

  • Buffers: shared hit=4
16. 0.007 0.007 ↑ 1.0 1 1

Index Scan using vendor_pkey on vendor (cost=0.42..8.44 rows=1 width=85) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (uuid = '7000c8b5-1327-4d8e-b0cf-b47e09945abd'::uuid)
  • Buffers: shared hit=4
17. 0.500 0.500 ↑ 1.0 1 100

Index Scan using payment_pkey on payment (cost=0.56..7.75 rows=1 width=72) (actual time=0.004..0.005 rows=1 loops=100)

  • Index Cond: (uuid = orders.payment_uuid)
  • Buffers: shared hit=500
18. 0.500 0.500 ↑ 1.0 1 100

Index Scan using transmission_pkey on transmission (cost=0.56..7.71 rows=1 width=58) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (uuid = orders.transmission_uuid)
  • Buffers: shared hit=501
19. 0.500 0.500 ↑ 1.0 1 100

Index Scan using address_pkey on address (cost=0.56..7.63 rows=1 width=173) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (uuid = orders.address_uuid)
  • Buffers: shared hit=502
20. 0.095 0.100 ↑ 1.0 11 100

Materialize (cost=0.00..1.17 rows=11 width=73) (actual time=0.000..0.001 rows=11 loops=100)

  • Buffers: shared hit=1
21. 0.005 0.005 ↑ 1.0 11 1

Seq Scan on delivery_time (cost=0.00..1.11 rows=11 width=73) (actual time=0.004..0.005 rows=11 loops=1)

  • Buffers: shared hit=1
22. 0.097 0.100 ↑ 1.0 11 100

Materialize (cost=0.00..1.17 rows=11 width=73) (actual time=0.000..0.001 rows=11 loops=100)

  • Buffers: shared hit=1
23. 0.003 0.003 ↑ 1.0 11 1

Seq Scan on delivery_time promised_delivery_time (cost=0.00..1.11 rows=11 width=73) (actual time=0.001..0.003 rows=11 loops=1)

  • Buffers: shared hit=1