explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rx1k

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,903.158 ↑ 1.0 10 1

Aggregate (cost=564,232.06..564,264.89 rows=10 width=200) (actual time=9,901.159..9,903.158 rows=10 loops=1)

  • Buffers: shared hit=2 read=365484 dirtied=1 written=6746
2. 0.000 10,190.933 ↑ 1.8 40 1

Gather Merge (cost=564,232.06..564,261.89 rows=70 width=200) (actual time=9,900.94..10,190.933 rows=40 loops=1)

  • Buffers: shared hit=392 read=2614826 dirtied=1 written=52125
3. 6.240 79,130.240 ↑ 2.0 5 8

Aggregate (cost=563,231.94..563,253.2 rows=10 width=200) (actual time=9,890.425..9,891.28 rows=5 loops=8)

  • Buffers: shared hit=392 read=2614826 dirtied=1 written=52125
4. 23.744 79,124.000 ↓ 2.6 1,687 8

Sort (cost=563,231.94..563,233.56 rows=648 width=88) (actual time=9,890.398..9,890.5 rows=1,687 loops=8)

  • Sort Key: tt.trans_completed_day, tt.domain_id, tt.user_id, tt.trans_type, tt.debit_vendor_id, tt.credit_vendor_id, tt.debit_real_currency, tt.credit_real_currency
  • Sort Method: quicksort Memory: 642kB
  • Buffers: shared hit=392 read=2614826 dirtied=1 written=52125
5. 8,559.008 79,100.256 ↓ 2.6 1,687 8

Hash Join (cost=0.35..563,201.68 rows=648 width=88) (actual time=4,945.23..9,887.532 rows=1,687 loops=8)

  • Buffers: shared hit=189 read=2614826 dirtied=1 written=52125
6. 6,297.350 70,540.936 ↑ 1.1 8,799,014 8

Append (cost=0..487,782.1 rows=10,055,033 width=53) (actual time=0.068..8,817.617 rows=8,799,014 loops=8)

  • Buffers: shared hit=6 read=2614826 dirtied=1 written=52125
7. 0.054 0.054 ↓ 0.0 0 1

Index Scan using idx_fact_transactions_defaul_domain_id_created on fact_transactions_defaul t_2 (cost=0.14..2.2 rows=1 width=61) (actual time=0.054..0.054 rows=0 loops=1)

  • Index Cond: ((t_2.trans_created >= '2019-04-06 00:00:00'::timestamp without time zone) AND (t_2.trans_created < '2019-04-08 00:00:00'::timestamp without time zone))
  • Filter: (t_2.trans_status = 1)
  • Buffers: shared hit=2
8. 34,665.136 34,665.136 ↑ 1.1 4,675,527 8

Seq Scan on fact_transactions_2019_04_06 t (cost=0..232,494.26 rows=5,343,336 width=53) (actual time=0.071..4,333.142 rows=4,675,527 loops=8)

  • Filter: ((t.trans_created >= '2019-04-06 00:00:00'::timestamp without time zone) AND (t.trans_created < '2019-04-08 00:00:00'::timestamp without time zone) AND (t.trans_status = 1))
  • Buffers: shared read=1389547 written=32186
9. 29,578.396 29,578.396 ↓ 1.8 8,246,974 4

Seq Scan on fact_transactions_2019_04_07 t_1 (cost=0..205,010.47 rows=4,711,696 width=53) (actual time=0.057..7,394.599 rows=8,246,974 loops=4)

  • Filter: ((t_1.trans_created >= '2019-04-06 00:00:00'::timestamp without time zone) AND (t_1.trans_created < '2019-04-08 00:00:00'::timestamp without time zone) AND (t_1.trans_status = 1))
  • Buffers: shared hit=4 read=1225279 dirtied=1 written=19939
10. 0.128 0.312 ↑ 1.0 10 8

Hash (cost=0.2..0.2 rows=10 width=104) (actual time=0.039..0.039 rows=10 loops=8)

  • Buffers: shared hit=8
11. 0.184 0.184 ↑ 1.0 10 8

Seq Scan on t_trans4process tt (cost=0..0.2 rows=10 width=104) (actual time=0.021..0.023 rows=10 loops=8)

  • Buffers: shared hit=8