explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NtC3

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 57.581 ↑ 1.0 1 1

Nested Loop (cost=996.93..1,189.24 rows=1 width=131) (actual time=57.340..57.581 rows=1 loops=1)

2. 0.010 57.558 ↑ 1.0 1 1

Nested Loop (cost=996.64..1,180.92 rows=1 width=131) (actual time=57.321..57.558 rows=1 loops=1)

3. 0.009 57.107 ↑ 1.0 1 1

Nested Loop Left Join (cost=996.64..1,098.92 rows=1 width=127) (actual time=57.103..57.107 rows=1 loops=1)

4. 2.573 57.090 ↑ 1.0 1 1

Hash Right Join (cost=996.49..1,090.74 rows=1 width=115) (actual time=57.088..57.090 rows=1 loops=1)

  • Hash Cond: (n2c.configuration_id = a.configuration_id)
5. 6.953 54.380 ↓ 1.0 3,981 1

HashAggregate (cost=985.18..1,024.86 rows=3,968 width=12) (actual time=51.457..54.380 rows=3,981 loops=1)

6. 6.135 47.427 ↓ 1.0 4,243 1

Hash Join (cost=667.78..964.06 rows=4,224 width=12) (actual time=25.130..47.427 rows=4,243 loops=1)

  • Hash Cond: (n.nlorderticket_id = nt.nlorderticket_id)
7. 6.512 32.823 ↓ 1.0 4,243 1

Hash Join (cost=468.18..701.10 rows=4,224 width=12) (actual time=16.639..32.823 rows=4,243 loops=1)

  • Hash Cond: (n2.nlorderticketitem_id = n.nlorderticketitem_id)
8. 6.736 19.219 ↓ 1.0 4,243 1

Hash Join (cost=235.53..389.25 rows=4,224 width=12) (actual time=9.525..19.219 rows=4,243 loops=1)

  • Hash Cond: (n2c.nlorderticketconf_id = n2.nlorderticketconf_id)
9. 3.029 3.029 ↓ 1.0 4,243 1

Seq Scan on nlorderconf2conf n2c (cost=0.00..69.24 rows=4,224 width=8) (actual time=0.005..3.029 rows=4,243 loops=1)

10. 4.630 9.454 ↑ 1.1 6,063 1

Hash (cost=154.68..154.68 rows=6,468 width=16) (actual time=9.454..9.454 rows=6,063 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 285kB
11. 4.824 4.824 ↑ 1.1 6,063 1

Seq Scan on nlorderticketconf n2 (cost=0.00..154.68 rows=6,468 width=16) (actual time=0.005..4.824 rows=6,063 loops=1)

12. 3.617 7.092 ↑ 1.0 4,807 1

Hash (cost=172.29..172.29 rows=4,829 width=16) (actual time=7.092..7.092 rows=4,807 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 226kB
13. 3.475 3.475 ↑ 1.0 4,807 1

Seq Scan on nlorderticketitem n (cost=0.00..172.29 rows=4,829 width=16) (actual time=0.004..3.475 rows=4,807 loops=1)

14. 1.510 8.469 ↓ 1.0 1,984 1

Hash (cost=174.81..174.81 rows=1,983 width=16) (actual time=8.469..8.469 rows=1,984 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
15. 2.804 6.959 ↓ 1.0 1,984 1

Hash Join (cost=89.23..174.81 rows=1,983 width=16) (actual time=2.836..6.959 rows=1,984 loops=1)

  • Hash Cond: (nt.nlorder_id = o.nlorder_id)
16. 1.339 1.339 ↓ 1.0 1,984 1

Seq Scan on nlorderticket nt (cost=0.00..55.83 rows=1,983 width=16) (actual time=0.003..1.339 rows=1,984 loops=1)

17. 1.402 2.816 ↑ 1.0 1,966 1

Hash (cost=64.66..64.66 rows=1,966 width=8) (actual time=2.816..2.816 rows=1,966 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 77kB
18. 1.414 1.414 ↑ 1.0 1,966 1

Seq Scan on nlorder o (cost=0.00..64.66 rows=1,966 width=8) (actual time=0.003..1.414 rows=1,966 loops=1)

19. 0.003 0.137 ↑ 1.0 1 1

Hash (cost=11.30..11.30 rows=1 width=107) (actual time=0.137..0.137 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
20. 0.066 0.134 ↑ 1.0 1 1

Hash Join (cost=8.31..11.30 rows=1 width=107) (actual time=0.126..0.134 rows=1 loops=1)

  • Hash Cond: (pd.product_id = a.product_id)
21. 0.052 0.052 ↑ 1.0 71 1

Seq Scan on product_definition pd (cost=0.00..2.71 rows=71 width=58) (actual time=0.009..0.052 rows=71 loops=1)

22. 0.006 0.016 ↑ 1.0 1 1

Hash (cost=8.30..8.30 rows=1 width=53) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
23. 0.010 0.010 ↑ 1.0 1 1

Index Scan using account_pkey on account a (cost=0.28..8.30 rows=1 width=53) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (account_id = 1555)
24. 0.008 0.008 ↓ 0.0 0 1

Index Scan using k_configuration_id on change_products (cost=0.15..8.17 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((configuration_id = a.configuration_id) AND ((state)::text = 'prepared'::text))
25. 0.441 0.441 ↑ 1.0 1 1

Seq Scan on service2bataccount sb (cost=0.00..81.99 rows=1 width=8) (actual time=0.210..0.441 rows=1 loops=1)

  • Filter: (account_id = 1555)
  • Rows Removed by Filter: 4811
26. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using configuration_pkey on configuration c (cost=0.29..8.31 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (configuration_id = a.configuration_id)
  • Heap Fetches: 1
Total runtime : 57.773 ms