explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U1t3 : Npo search

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 3,324.550 ↑ 80.3 3 1

Group (cost=4,493.310..4,494.510 rows=241 width=450) (actual time=3,324.545..3,324.550 rows=3 loops=1)

  • Group Key: "seven_romeo".quebec
2. 0.016 3,324.542 ↑ 80.3 3 1

Sort (cost=4,493.310..4,493.910 rows=241 width=450) (actual time=3,324.541..3,324.542 rows=3 loops=1)

  • Sort Key: "seven_romeo".quebec
  • Sort Method: quicksort Memory: 27kB
3. 3,166.704 3,324.526 ↑ 80.3 3 1

Hash Left Join (cost=2,978.370..4,483.770 rows=241 width=450) (actual time=598.719..3,324.526 rows=3 loops=1)

  • Hash Cond: ("charlie"."bravo" = "four_november".quebec)
  • Filter: ((sierra("seven_romeo".*) @@ mike('four_five'::text)) OR ((tango_mike."tango_kilo")::text ~~* 'xray_golf_juliet'::text) OR (("charlie".november)::text ~~* 'xray_golf_juliet'::text) OR (("four_november".november)::text ~~* 'xray_golf_juliet'::text) OR (("four_november".four_three)::text ~~* 'xray_golf_juliet'::text))
  • Rows Removed by Filter: 35119
4. 41.799 157.753 ↑ 1.0 35,122 1

Hash Left Join (cost=2,976.050..4,070.960 rows=35,692 width=943) (actual time=51.634..157.753 rows=35,122 loops=1)

  • Hash Cond: (tango_mike."seven_lima" = "charlie".quebec)
5. 32.709 97.471 ↑ 1.0 35,122 1

Hash Left Join (cost=2,064.070..3,065.280 rows=35,692 width=934) (actual time=33.126..97.471 rows=35,122 loops=1)

  • Hash Cond: ("seven_romeo".quebec = tango_mike."xray_golf_romeo")
6. 31.690 31.690 ↑ 1.0 7,026 1

Seq Scan on foxtrot seven_romeo (cost=0.000..584.010 rows=7,101 width=924) (actual time=0.023..31.690 rows=7,026 loops=1)

  • Filter: (NOT "two")
7. 15.953 33.072 ↑ 1.0 35,120 1

Hash (cost=1,617.920..1,617.920 rows=35,692 width=14) (actual time=33.071..33.072 rows=35,120 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2090kB
8. 17.119 17.119 ↑ 1.0 35,120 1

Seq Scan on kilo tango_mike (cost=0.000..1,617.920 rows=35,692 width=14) (actual time=0.010..17.119 rows=35,120 loops=1)

9. 10.705 18.483 ↑ 1.0 29,910 1

Hash (cost=538.100..538.100 rows=29,910 width=17) (actual time=18.483..18.483 rows=29,910 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1703kB
10. 7.778 7.778 ↑ 1.0 29,910 1

Seq Scan on papa charlie (cost=0.000..538.100 rows=29,910 width=17) (actual time=0.016..7.778 rows=29,910 loops=1)

11. 0.032 0.069 ↑ 1.0 59 1

Hash (cost=1.590..1.590 rows=59 width=17) (actual time=0.069..0.069 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
12. 0.037 0.037 ↑ 1.0 59 1

Seq Scan on six four_november (cost=0.000..1.590 rows=59 width=17) (actual time=0.017..0.037 rows=59 loops=1)