explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wqUR

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,361,946.861 ↑ 1.0 1 1

Limit (cost=614,361.20..614,361.21 rows=1 width=8) (actual time=1,361,946.858..1,361,946.861 rows=1 loops=1)

2. 17.562 1,361,946.856 ↑ 1.0 1 1

Aggregate (cost=614,361.20..614,361.21 rows=1 width=8) (actual time=1,361,946.855..1,361,946.856 rows=1 loops=1)

3. 655.063 1,361,929.294 ↑ 14.4 5,905 1

Nested Loop (cost=1.12..614,148.96 rows=84,897 width=0) (actual time=874,736.439..1,361,929.294 rows=5,905 loops=1)

4. 812,269.107 812,269.107 ↓ 1.1 97,827 1

Index Scan using pay_payment_status_index on pay_payment p (cost=0.56..20,817.67 rows=86,331 width=16) (actual time=0.111..812,269.107 rows=97,827 loops=1)

  • Index Cond: ((status)::text = ANY ('{NEW,CONFIRMED,PAY_STARTED,CONFIRM_3DS_STARTED,PAY_FAILED}'::text[]))
5. 549,005.124 549,005.124 ↓ 0.0 0 97,827

Index Scan using pay_payment_group_id_pk on pay_payment_group g (cost=0.56..6.86 rows=1 width=16) (actual time=5.610..5.612 rows=0 loops=97,827)

  • Index Cond: (payment_group_id = p.payment_group_id)
  • Filter: (created <= '2019-06-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 1