explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3l84

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 76,860.554 ↑ 1.0 500 1

Limit (cost=1,001.49..158,767.77 rows=500 width=813) (actual time=76,784.651..76,860.554 rows=500 loops=1)

2. 76.332 76,860.496 ↑ 152.8 500 1

Gather Merge (cost=1,001.49..24,111,792.03 rows=76,413 width=813) (actual time=76,784.650..76,860.496 rows=500 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.047 76,784.164 ↑ 180.2 106 5 / 5

Nested Loop (cost=1.43..24,101,690.45 rows=19,103 width=813) (actual time=76,608.519..76,784.164 rows=106 loops=5)

4. 11,513.277 76,783.903 ↑ 214.6 107 5 / 5

Nested Loop (cost=1.14..24,094,511.47 rows=22,967 width=813) (actual time=76,608.490..76,783.903 rows=107 loops=5)

5. 13,300.947 13,300.947 ↑ 1.3 17,323,226 5 / 5

Parallel Index Scan using payments_pkey on payments (cost=0.57..5,556,967.34 rows=21,714,107 width=813) (actual time=0.029..13,300.947 rows=17,323,226 loops=5)

6. 51,969.679 51,969.679 ↓ 0.0 0 86,616,131 / 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,616,131)

  • 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 16:59:59.999999'::timestamp without
  • Rows Removed by Filter: 1
7. 0.214 0.214 ↑ 1.0 1 534 / 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=534)

  • Index Cond: (id = payments.account_id)
  • Filter: (psp_id = 1)
  • Rows Removed by Filter: 0
Planning time : 1.302 ms
Execution time : 76,860.667 ms