explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vt3h

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 1,888,304.364 ↑ 1.0 10 1

Limit (cost=1.12..74.59 rows=10 width=722) (actual time=1,888,185.540..1,888,304.364 rows=10 loops=1)

2. 675.208 1,888,304.348 ↑ 7,145.8 10 1

Nested Loop (cost=1.12..524,967.98 rows=71,458 width=722) (actual time=1,888,185.537..1,888,304.348 rows=10 loops=1)

3. 1,408,134.199 1,408,134.199 ↑ 1.1 67,449 1

Index Scan using pay_payment_status_index on pay_payment p (cost=0.56..21,428.96 rows=71,978 width=532) (actual time=0.097..1,408,134.199 rows=67,449 loops=1)

  • Index Cond: ((status)::text = ANY ('{NEW,CONFIRMED,PAY_STARTED,CONFIRM_3DS_STARTED,PAY_FAILED}'::text[]))
4. 479,494.941 479,494.941 ↓ 0.0 0 67,449

Index Scan using pay_payment_group_id_pk on pay_payment_group g (cost=0.56..6.99 rows=1 width=190) (actual time=7.109..7.109 rows=0 loops=67,449)

  • Index Cond: (payment_group_id = p.payment_group_id)
  • Filter: (created <= '2019-06-06 00:00:00.001'::timestamp without time zone)
  • Rows Removed by Filter: 1
Planning time : 124.654 ms
Execution time : 1,888,304.579 ms