explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tPda

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 79.432 ↑ 11.8 12 1

HashAggregate (cost=15,673.28..15,674.69 rows=141 width=32) (actual time=79.430..79.432 rows=12 loops=1)

  • Group Key: ('textdsfsdfdsfs'::text)
2. 0.003 79.409 ↑ 5.2 27 1

Append (cost=15,262.54..15,672.93 rows=141 width=32) (actual time=76.503..79.409 rows=27 loops=1)

3. 0.003 77.253 ↑ 7.8 16 1

Subquery Scan on *SELECT* 1 (cost=15,262.54..15,265.98 rows=125 width=32) (actual time=76.502..77.253 rows=16 loops=1)

4. 0.639 77.250 ↑ 7.8 16 1

GroupAggregate (cost=15,262.54..15,264.73 rows=125 width=33) (actual time=76.501..77.250 rows=16 loops=1)

  • Group Key: p.external_payment_reference
  • Filter: (count(*) > 2)
  • Rows Removed by Filter: 2444
5. 12.010 76.611 ↓ 21.5 2,691 1

Sort (cost=15,262.54..15,262.85 rows=125 width=1) (actual time=76.416..76.611 rows=2,691 loops=1)

  • Sort Key: p.external_payment_reference
  • Sort Method: quicksort Memory: 223kB
6. 4.582 64.601 ↓ 21.5 2,691 1

Nested Loop (cost=0.42..15,258.18 rows=125 width=1) (actual time=19.372..64.601 rows=2,691 loops=1)

7. 2.539 2.539 ↓ 1.0 11,496 1

Seq Scan on hi_pay_queue h (cost=0.00..339.09 rows=11,209 width=16) (actual time=0.007..2.539 rows=11,496 loops=1)

8. 57.480 57.480 ↓ 0.0 0 11,496

Index Scan using payment_information_pkey on payment_information p (cost=0.42..1.32 rows=1 width=17) (actual time=0.005..0.005 rows=0 loops=11,496)

  • Index Cond: (id = h.payment_information_id)
  • Filter: ((payment_type <> 'BANK_TRANSFER_HIPAY_VIBAN'::text) AND ((state)::text = 'FINALIZED'::text))
  • Rows Removed by Filter: 1
9. 0.002 2.153 ↑ 1.5 11 1

Subquery Scan on *SELECT* 2 (cost=406.67..406.95 rows=16 width=32) (actual time=2.135..2.153 rows=11 loops=1)

10. 0.049 2.151 ↑ 1.5 11 1

Group (cost=406.67..406.79 rows=16 width=33) (actual time=2.134..2.151 rows=11 loops=1)

  • Group Key: p_1.external_payment_reference
11. 0.054 2.102 ↑ 1.5 11 1

Sort (cost=406.67..406.71 rows=16 width=1) (actual time=2.101..2.102 rows=11 loops=1)

  • Sort Key: p_1.external_payment_reference
  • Sort Method: quicksort Memory: 25kB
12. 0.006 2.048 ↑ 1.5 11 1

Nested Loop (cost=0.42..406.35 rows=16 width=1) (actual time=1.742..2.048 rows=11 loops=1)

13. 1.922 1.922 ↓ 1.2 20 1

Seq Scan on hi_pay_queue h_1 (cost=0.00..367.11 rows=16 width=16) (actual time=1.531..1.922 rows=20 loops=1)

  • Filter: (operation_id = 'refund#finalize'::text)
  • Rows Removed by Filter: 11476
14. 0.120 0.120 ↑ 1.0 1 20

Index Scan using payment_information_pkey on payment_information p_1 (cost=0.42..2.44 rows=1 width=17) (actual time=0.006..0.006 rows=1 loops=20)

  • Index Cond: (id = h_1.payment_information_id)
  • Filter: (payment_type <> 'BANK_TRANSFER_HIPAY_VIBAN'::text)
  • Rows Removed by Filter: 0
Planning time : 0.660 ms
Execution time : 79.680 ms