explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gwCH

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 7,385.042 ↑ 1.0 1 1

Result (cost=1,926,660.12..1,926,660.14 rows=1 width=0) (actual time=7,385.042..7,385.042 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.041 4,101.618 ↑ 1.0 1 1

Result (cost=963,330.04..963,330.06 rows=1 width=0) (actual time=4,101.618..4,101.618 rows=1 loops=1)

4.          

Initplan (forResult)

5. 0.043 2,498.974 ↑ 1.0 1 1

Aggregate (cost=484,933.49..484,933.50 rows=1 width=4) (actual time=2,498.974..2,498.974 rows=1 loops=1)

6. 0.380 2,498.931 ↓ 1.9 459 1

HashAggregate (cost=484,928.05..484,930.47 rows=242 width=4) (actual time=2,498.879..2,498.931 rows=459 loops=1)

  • Group Key: fp.payment_fds_id
7. 0.073 2,498.551 ↓ 1.9 459 1

Append (cost=0.00..484,927.44 rows=242 width=4) (actual time=754.910..2,498.551 rows=459 loops=1)

8. 1,226.955 1,226.955 ↓ 1.4 169 1

Seq Scan on tbpayment_fds fp (cost=0.00..233,974.02 rows=119 width=4) (actual time=754.897..1,226.955 rows=169 loops=1)

  • Filter: ((state_fds_id = '-4'::integer) AND (create_date > (now() - '00:07:00'::interval)))
  • Rows Removed by Filter: 1288649
9. 985.929 985.929 ↓ 2.7 261 1

Seq Scan on tboperation_fds fop (cost=0.00..219,011.26 rows=95 width=4) (actual time=598.041..985.929 rows=261 loops=1)

  • Filter: ((state_fds_id = '-4'::integer) AND (create_date > (now() - '00:07:00'::interval)))
  • Rows Removed by Filter: 1051960
10. 285.594 285.594 ↓ 1.0 29 1

Seq Scan on tbfree_requisites_fds ffr (cost=0.00..31,939.74 rows=28 width=4) (actual time=278.816..285.594 rows=29 loops=1)

  • Filter: ((state_fds_id = '-4'::integer) AND (create_date > (now() - '00:07:00'::interval)))
  • Rows Removed by Filter: 321384
11. 0.042 1,602.603 ↑ 1.0 1 1

Aggregate (cost=478,396.53..478,396.54 rows=1 width=4) (actual time=1,602.603..1,602.603 rows=1 loops=1)

12. 0.258 1,602.561 ↓ 1.9 484 1

HashAggregate (cost=478,390.66..478,393.27 rows=261 width=4) (actual time=1,602.493..1,602.561 rows=484 loops=1)

  • Group Key: fp_1.payment_fds_id
13. 203.126 1,602.303 ↓ 1.9 484 1

Append (cost=0.00..478,390.00 rows=261 width=4) (actual time=572.490..1,602.303 rows=484 loops=1)

  • -> Seq Scan on tbfree_requisites_fds ffr_1 (cost=0.00..31145.40 rows=32 width=4) (actual time=199.693..203.081 rows=31 loops=
14. 773.457 773.457 ↓ 1.4 177 1

Seq Scan on tbpayment_fds fp_1 (cost=0.00..230,814.64 rows=126 width=4) (actual time=572.489..773.457 rows=177 loops=1)

  • Filter: (create_date > (now() - '00:07:00'::interval))
  • Rows Removed by Filter: 1288641
15. 625.720 625.720 ↓ 2.7 276 1

Seq Scan on tboperation_fds fop_1 (cost=0.00..216,427.35 rows=103 width=4) (actual time=455.953..625.720 rows=276 loops=1)

  • Filter: (create_date > (now() - '00:07:00'::interval))
  • Rows Removed by Filter: 1051945
  • Filter: (create_date > (now() - '00:07:00'::interval))
  • Rows Removed by Filter: 321382
16. 0.029 3,283.331 ↑ 1.0 1 1

Result (cost=963,330.04..963,330.06 rows=1 width=0) (actual time=3,283.330..3,283.331 rows=1 loops=1)

17.          

Initplan (forResult)

18. 0.049 1,635.827 ↑ 1.0 1 1

Aggregate (cost=484,933.49..484,933.50 rows=1 width=4) (actual time=1,635.827..1,635.827 rows=1 loops=1)

19. 0.262 1,635.778 ↓ 1.9 459 1

HashAggregate (cost=484,928.05..484,930.47 rows=242 width=4) (actual time=1,635.715..1,635.778 rows=459 loops=1)

  • Group Key: fp_2.payment_fds_id
20. 209.919 1,635.516 ↓ 1.9 459 1

Append (cost=0.00..484,927.44 rows=242 width=4) (actual time=585.091..1,635.516 rows=459 loops=1)

  • -> Seq Scan on tbfree_requisites_fds ffr_2 (cost=0.00..31939.74 rows=28 width=4) (actual time=206.352..209.866 rows=29 loops=
21. 787.711 787.711 ↓ 1.4 169 1

Seq Scan on tbpayment_fds fp_2 (cost=0.00..233,974.02 rows=119 width=4) (actual time=585.088..787.711 rows=169 loops=1)

  • Filter: ((state_fds_id = '-4'::integer) AND (create_date > (now() - '00:07:00'::interval)))
  • Rows Removed by Filter: 1288649
22. 637.886 637.886 ↓ 2.7 261 1

Seq Scan on tboperation_fds fop_2 (cost=0.00..219,011.26 rows=95 width=4) (actual time=469.117..637.886 rows=261 loops=1)

  • Filter: ((state_fds_id = '-4'::integer) AND (create_date > (now() - '00:07:00'::interval)))
  • Rows Removed by Filter: 1051960
  • Filter: ((state_fds_id = '-4'::integer) AND (create_date > (now() - '00:07:00'::interval)))
  • Rows Removed by Filter: 321384
23. 0.074 1,647.475 ↑ 1.0 1 1

Aggregate (cost=478,396.53..478,396.54 rows=1 width=4) (actual time=1,647.474..1,647.475 rows=1 loops=1)

24. 0.273 1,647.401 ↓ 1.9 484 1

HashAggregate (cost=478,390.66..478,393.27 rows=261 width=4) (actual time=1,647.295..1,647.401 rows=484 loops=1)

  • Group Key: fp_3.payment_fds_id
25. 268.700 1,647.128 ↓ 1.9 484 1

Append (cost=0.00..478,390.00 rows=261 width=4) (actual time=558.652..1,647.128 rows=484 loops=1)

  • -> Seq Scan on tbfree_requisites_fds ffr_3 (cost=0.00..31145.40 rows=32 width=4) (actual time=264.297..268.658 rows=31 loops=
26. 760.377 760.377 ↓ 1.4 177 1

Seq Scan on tbpayment_fds fp_3 (cost=0.00..230,814.64 rows=126 width=4) (actual time=558.650..760.377 rows=177 loops=1)

  • Filter: (create_date > (now() - '00:07:00'::interval))
  • Rows Removed by Filter: 1288641
27. 618.051 618.051 ↓ 2.7 276 1

Seq Scan on tboperation_fds fop_3 (cost=0.00..216,427.35 rows=103 width=4) (actual time=445.902..618.051 rows=276 loops=1)

  • Filter: (create_date > (now() - '00:07:00'::interval))
  • Rows Removed by Filter: 1051945
  • Filter: (create_date > (now() - '00:07:00'::interval))
  • Rows Removed by Filter: 321382
Planning time : 1.668 ms
Execution time : 7,385.326 ms