explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NDiM

Settings
# exclusive inclusive rows x rows loops node
1. 90.330 4,525.057 ↓ 1.4 773 1

Gather (cost=1,003.47..1,768,260.69 rows=557 width=23) (actual time=16.239..4,525.057 rows=773 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.956 4,434.727 ↓ 1.1 258 3

Hash Join (cost=3.46..1,767,204.99 rows=232 width=23) (actual time=25.968..4,434.727 rows=258 loops=3)

  • Hash Cond: (m.country_id = c.id)
3. 8.285 4,433.713 ↓ 1.1 258 3

Nested Loop (cost=1.70..1,767,202.54 rows=232 width=24) (actual time=25.753..4,433.713 rows=258 loops=3)

4. 3,010.449 4,425.399 ↓ 1.1 258 3

Nested Loop (cost=1.27..1,765,369.36 rows=232 width=24) (actual time=25.689..4,425.399 rows=258 loops=3)

5. 1,414.922 1,414.922 ↑ 1.8 103,671 3

Parallel Index Scan using transactions_server_time_created_at_idx on transactions t (cost=0.57..240,139.86 rows=183,108 width=45) (actual time=0.227..1,414.922 rows=103,671 loops=3)

  • Index Cond: ((server_time_created_at >= '2018-10-01 00:00:00'::timestamp without time zone) AND (server_time_created_at < '2018-10-02 00:00:00'::timestamp without time zone))
  • Filter: ((tx_result)::text = ANY ('{11,12}'::text[]))
  • Rows Removed by Filter: 36021
6. 0.028 0.028 ↓ 0.0 0 311,013

Index Scan using index_transaction_receipts_on_server_transaction_id on transaction_receipts tr (cost=0.70..8.32 rows=1 width=53) (actual time=0.028..0.028 rows=0 loops=311,013)

  • Index Cond: ((server_transaction_id)::text = (t.server_transaction_id)::text)
  • Filter: (r_refund_num IS NOT NULL)
  • Rows Removed by Filter: 1
7. 0.029 0.029 ↑ 1.0 1 773

Index Scan using merchants_pkey on merchants m (cost=0.43..7.90 rows=1 width=8) (actual time=0.029..0.029 rows=1 loops=773)

  • Index Cond: (id = t.merchant_id)
8. 0.024 0.058 ↑ 1.0 34 3

Hash (cost=1.34..1.34 rows=34 width=7) (actual time=0.057..0.058 rows=34 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.034 0.034 ↑ 1.0 34 3

Seq Scan on countries c (cost=0.00..1.34 rows=34 width=7) (actual time=0.017..0.034 rows=34 loops=3)