explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b9QR

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 75,747.860 ↑ 1.0 500 1

Limit (cost=1,001.49..155,456.18 rows=500 width=814) (actual time=75,684.405..75,747.860 rows=500 loops=1)

2. 20.372 75,747.816 ↑ 156.0 500 1

Gather Merge (cost=1,001.49..24,101,494.57 rows=78,018 width=814) (actual time=75,684.404..75,747.816 rows=500 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.036 75,727.444 ↑ 184.0 106 5 / 5

Nested Loop (cost=1.43..24,091,201.81 rows=19,504 width=814) (actual time=75,538.768..75,727.444 rows=106 loops=5)

4. 10,696.610 75,727.196 ↑ 221.2 106 5 / 5

Nested Loop (cost=1.14..24,083,872.17 rows=23,449 width=814) (actual time=75,538.740..75,727.196 rows=106 loops=5)

5. 13,061.006 13,061.006 ↑ 1.3 17,323,193 5 / 5

Parallel Index Scan using payments_pkey on payments (cost=0.57..5,547,922.04 rows=21,711,557 width=814) (actual time=0.008..13,061.006 rows=17,323,193 loops=5)

6. 51,969.580 51,969.580 ↓ 0.0 0 86,615,966 / 5

Index Scan using charges_pkey on charges (cost=0.57..0.85 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=86,615,966)

  • Index Cond: (id = payments.charge_id)
  • Filter: (live AND (captured_at >= '2020-09-01 17:00:00'::timestamp without time zone) AND (captured_at < '2020-09-02 17:00:00'::timestamp without time zo
  • Rows Removed by Filter: 1
7. 0.212 0.212 ↑ 1.0 1 530 / 5

Index Scan using accounts_pkey on accounts (cost=0.29..0.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=530)

  • Index Cond: (id = payments.account_id)
  • Filter: (psp_id = 1)
  • Rows Removed by Filter: 0
Planning time : 0.486 ms
Execution time : 75,747.984 ms