explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IPUo

Settings
# exclusive inclusive rows x rows loops node
1. 0.233 2,108.909 ↑ 1.0 20 1

Limit (cost=36,691.37..36,693.74 rows=20 width=1,092) (actual time=1,861.318..2,108.909 rows=20 loops=1)

2. 0.000 2,108.676 ↑ 2.7 20 1

Gather Merge (cost=36,691.37..36,697.76 rows=54 width=1,092) (actual time=1,861.312..2,108.676 rows=20 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 0.952 5,542.280 ↑ 3.6 5 4

Sort (cost=35,691.33..35,691.38 rows=18 width=1,092) (actual time=1,385.557..1,385.570 rows=5 loops=4)

  • Sort Key: tender_lots.tender_lot_date_stop DESC
  • Sort Method: quicksort Memory: 29kB
  • Worker 0: Sort Method: quicksort Memory: 37kB
  • Worker 1: Sort Method: quicksort Memory: 35kB
  • Worker 2: Sort Method: quicksort Memory: 29kB
4. 1.240 5,541.328 ↑ 3.6 5 4

Hash Join (cost=6,516.85..35,690.96 rows=18 width=1,092) (actual time=745.362..1,385.332 rows=5 loops=4)

  • Hash Cond: (tender_lots.currency_id = currencies.currency_id)
5. 0.428 5,539.000 ↑ 3.6 5 4

Hash Join (cost=6,515.78..35,689.69 rows=18 width=1,437) (actual time=744.831..1,384.750 rows=5 loops=4)

  • Hash Cond: (tender_lots.tender_lot_type_id = tender_lot_types.tender_lot_type_id)
6. 164.544 5,537.972 ↑ 3.6 5 4

Hash Join (cost=6,514.56..35,688.39 rows=18 width=1,368) (actual time=744.601..1,384.493 rows=5 loops=4)

  • Hash Cond: (tender_lots.tender_lot_id = lot_bids.auctionid)
7. 335.236 5,370.612 ↑ 1.3 19,688 4

Hash Join (cost=6,467.99..35,576.10 rows=24,963 width=1,372) (actual time=376.906..1,342.653 rows=19,688 loops=4)

  • Hash Cond: (tender_lots.delivery_entity_id = delivery_entities.delivery_entity_id)
8. 333.608 5,034.592 ↑ 1.3 19,688 4

Hash Join (cost=6,466.54..35,495.24 rows=24,963 width=1,335) (actual time=376.646..1,258.648 rows=19,688 loops=4)

  • Hash Cond: (tender_lots.tender_lot_state_id = tender_lot_states.tender_lot_state_id)
9. 337.440 4,700.388 ↑ 1.3 19,688 4

Hash Join (cost=6,465.30..35,403.22 rows=24,963 width=1,299) (actual time=376.449..1,175.097 rows=19,688 loops=4)

  • Hash Cond: (tender_lots.category_id = categories.category_id)
10. 357.604 4,359.476 ↑ 1.3 19,688 4

Parallel Hash Join (cost=6,453.65..35,324.33 rows=24,963 width=1,232) (actual time=375.470..1,089.869 rows=19,688 loops=4)

  • Hash Cond: (users.company_id = companies.company_id)
11. 353.084 3,776.768 ↑ 1.3 19,688 4

Hash Join (cost=4,255.19..33,060.34 rows=24,963 width=1,209) (actual time=318.005..944.192 rows=19,688 loops=4)

  • Hash Cond: (tenders.user_id = users.user_id)
12. 447.760 2,396.524 ↑ 1.3 19,688 4

Parallel Hash Join (cost=2,552.27..31,291.90 rows=24,963 width=1,205) (actual time=60.292..599.131 rows=19,688 loops=4)

  • Hash Cond: (tender_lots.tender_id = tenders.tender_id)
13. 546.038 1,711.420 ↑ 1.3 19,688 4

Nested Loop (cost=0.29..28,674.38 rows=24,963 width=784) (actual time=0.188..427.855 rows=19,688 loops=4)

14. 281.112 281.112 ↑ 1.3 22,107 4

Parallel Seq Scan on tender_lot_data (cost=0.00..9,631.25 rows=28,525 width=8) (actual time=0.040..70.278 rows=22,107 loops=4)

15. 884.270 884.270 ↑ 1.0 1 88,427

Index Scan using tender_lots_pkey on tender_lots (cost=0.29..0.67 rows=1 width=776) (actual time=0.010..0.010 rows=1 loops=88,427)

  • Index Cond: (tender_lot_id = tender_lot_data.tender_lot_id)
  • Filter: ((tender_lot_is_active IS TRUE) AND (tender_lot_state_id = ANY ('{2,3,4,5,240,280,335,336,416}'::integer[])))
  • Rows Removed by Filter: 0
16. 150.536 237.344 ↑ 2.4 8,878 4

Parallel Hash (cost=2,290.88..2,290.88 rows=20,888 width=425) (actual time=59.333..59.336 rows=8,878 loops=4)

  • Buckets: 65536 Batches: 1 Memory Usage: 16736kB
17. 86.808 86.808 ↑ 1.2 17,755 2

Parallel Seq Scan on tenders_new tenders (cost=0.00..2,290.88 rows=20,888 width=425) (actual time=0.028..43.404 rows=17,755 loops=2)

18. 524.628 1,027.160 ↑ 1.0 58,974 4

Hash (cost=965.74..965.74 rows=58,974 width=8) (actual time=256.788..256.790 rows=58,974 loops=4)

  • Buckets: 65536 Batches: 1 Memory Usage: 2816kB
19. 502.532 502.532 ↑ 1.0 58,974 4

Seq Scan on users (cost=0.00..965.74 rows=58,974 width=8) (actual time=0.132..125.633 rows=58,974 loops=4)

20. 123.859 225.104 ↑ 2.4 12,815 4

Parallel Hash (cost=1,821.54..1,821.54 rows=30,154 width=27) (actual time=56.274..56.276 rows=12,815 loops=4)

  • Buckets: 65536 Batches: 1 Memory Usage: 3712kB
21. 101.245 101.245 ↓ 1.7 51,261 1

Parallel Seq Scan on companies (cost=0.00..1,821.54 rows=30,154 width=27) (actual time=0.022..101.245 rows=51,261 loops=1)

22. 1.548 3.472 ↑ 1.0 162 4

Hash (cost=9.62..9.62 rows=162 width=71) (actual time=0.865..0.868 rows=162 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
23. 1.924 1.924 ↑ 1.0 162 4

Seq Scan on categories (cost=0.00..9.62 rows=162 width=71) (actual time=0.102..0.481 rows=162 loops=4)

24. 0.136 0.596 ↑ 1.0 11 4

Hash (cost=1.11..1.11 rows=11 width=40) (actual time=0.147..0.149 rows=11 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.460 0.460 ↑ 1.0 11 4

Seq Scan on tender_lot_states (cost=0.00..1.11 rows=11 width=40) (actual time=0.093..0.115 rows=11 loops=4)

26. 0.204 0.784 ↑ 1.0 20 4

Hash (cost=1.20..1.20 rows=20 width=41) (actual time=0.194..0.196 rows=20 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
27. 0.580 0.580 ↑ 1.0 20 4

Seq Scan on delivery_entities (cost=0.00..1.20 rows=20 width=41) (actual time=0.106..0.145 rows=20 loops=4)

28. 0.212 2.816 ↑ 3.0 22 4

Hash (cost=45.75..45.75 rows=65 width=4) (actual time=0.701..0.704 rows=22 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.584 2.604 ↑ 3.0 22 4

HashAggregate (cost=45.10..45.75 rows=65 width=4) (actual time=0.608..0.651 rows=22 loops=4)

  • Group Key: lot_bids.auctionid
30. 2.020 2.020 ↑ 1.5 44 4

Index Scan using ix_au_bids on lot_bids (cost=0.42..44.94 rows=65 width=4) (actual time=0.089..0.505 rows=44 loops=4)

  • Index Cond: (biddercompid = 612)
  • Filter: isactive
  • Rows Removed by Filter: 24
31. 0.140 0.600 ↑ 1.0 10 4

Hash (cost=1.10..1.10 rows=10 width=73) (actual time=0.148..0.150 rows=10 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
32. 0.460 0.460 ↑ 1.0 10 4

Seq Scan on tender_lot_types (cost=0.00..1.10 rows=10 width=73) (actual time=0.093..0.115 rows=10 loops=4)

33. 0.104 1.088 ↑ 1.0 3 4

Hash (cost=1.03..1.03 rows=3 width=11) (actual time=0.270..0.272 rows=3 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.984 0.984 ↑ 1.0 3 4

Seq Scan on currencies (cost=0.00..1.03 rows=3 width=11) (actual time=0.238..0.246 rows=3 loops=4)

Planning time : 17.569 ms